You have a Employe table with EmpId, EmpName, EmpAge. There are 5 records as of now. EmpId is a primary key with identity column. Now the identity value is 5. You need to start the identity value from 10 instead of 6. Write the query for that?

Answer:

We need to add identity column value explicitly. For that we can use the following query:

Set identity_insert EmployeMaster on 

  Insert into EmployeMaster(EmpId, EmpName, EmpAge)

  values (10,'Shankar',19)

In the above query I mentioned "Identity_Insert on" for table name EmployeeMaster. Second I specified all the column names and inserted the values corresponding to tht column. Now we will be having identity value as 10.