In my last week interview, The question asked
you have one table as 'table1' which comprises only one column as 'ColID' set as 'IDENTITY'.
Now, you have to insert 10 records with simple INSERT statement. How will you do ? (important: The IDENTITY value should be inserted automatically, not manually)
But, I don't know the answer. Can anybody pl give me the answer ?