How To Install A Instance In SQL Server In this tutorial i will explain you How To Install A Instance In SQL Server.SQL Server instance is a complete SQL server and you can install upto 50 instances in a SQL server 2008 and SQL server 2005 on a machine but you can have only 1 default instance. An […]
Author: Mandeep Singh
Categories
How to use AND & OR in Sql server
Both AND & OR are used to filter records on more than one condition. AND & OR AND operator displays a records if first condition and second condition is true. OR operator displays a records if either first condition or second condition is true. Example Table:- ID Name Class Roll No 1 Jai B.A 12 2 Mohan […]
Categories
How to use where clause in Sql server
The WHERE clause is used to find only records that fulfill a specified criteria. Where Syntax:- Select * from table name where city=’city name’ Example Table:- ID Name Class Roll No 1 Jai B.A 12 2 Mohan M.A 23 4 Om B.A 2 Select * from example where class=’B.A’ Result:- ID Name Class Roll No 1 […]
In tables some of the columns may contain duplicate values. But you want to list out the (distinct) values of a coloum in that table. The DISTINCT keyword can be used to return only distinct (different) values. First of all create a table. create table dept_test( Deptno int,dname varchar(20),loc varchar(20)) Then insert records into the table you […]