Create/Alter/Drop table

Create Table:
                          CREATE TABLE Employee_Mst

                          (

                           Id int , 

                          varFirstName varchar(30), 

                          varLastName varchar(30)

                          );

• if you want to Add  Primary key in Employee_Mst Table use Alter Function:
• -Ex: Alter table Employee_Mst ADD  PRIMARY KEY (Id);

• if you want to Add Column in Employee_Mst also use Alter Function:
• -Ex: Alter table Employee_Mst ADD varAddress varchar(255)

• if you want to Drop Column in Employee_Mst also use Alter Function:
• -Ex: Alter table Employee_Mst Drop varAddress

• if you want to Drop table  Employee_Mst Drop Function use:
• -Ex: Drop table Employee_Mst

Reset Identity Column use CHECKIDENT Command

Reset Identity Column : DBCC CHECKIDENT (Table_Name, RESEED, 0)

If you are using an identity column on your SQL Server tables, you can set the next insert value to whatever value you want.
Ex:- DBCC CHECKIDENT (Table_Name, RESEED, 100)
Now your identity number start with 101 Number.

Select/Delete Multiple Record Using IN Command

Select Query:
Select * from Employee_Mst Where Id IN (1,2,3)
Select * from Employee_Mst Where varEmpname IN ('Nirav','Ashish','Rahul')

Delete Query:
Delete from Employee_Mst Where Id IN (1,2,3)
Delete from Employee_Mst Where varEmpname IN ('Nirav','Ashish','Rahul')

Returning a Row Number in a Query

SELECT varEmpname,decAmount,varState
    ROW_NUMBER() OVER (ORDER BY varEmpname) AS 'RowNumber'
    FROM Employee_mst

RowNumber varEmpname decAmount  varState

 1        Nirav      15,000     Gujarat

 2        Ashish     25,000     Mumbai

Pivot Command in sql

SELECT [CA], [AZ], [TX]
FROM
(
SELECT sp.StateProvinceCode
FROM Person.Address a
INNER JOIN Person.StateProvince sp
ON a.StateProvinceID = sp.StateProvinceID
) p
PIVOT
(
COUNT (StateProvinceCode)
FOR StateProvinceCode
IN ([CA], [AZ], [TX])
) AS pvt;