I have a table with only one column that too identity column. How can you insert the data? Say for example:

CREATE TABLE OnlyIdentity
(
NSID int identity(1,1)
)

 Posted by Nagasundar_Tn on 12/3/2012 | Category: Sql Server Interview questions | Views: 3559 | Points: 40
Select from following answers:
  1. Insert into OnlyIdentity values (DEFAULT)
  2. Insert into OnlyIdentity DEFAULT VALUES
  3. Insert into OnlyIdentity DEFAULT
  4. Insert into OnlyIdentity values (1)
  5. All Above

Show Correct Answer


Asked In: NIIT interview | Alert Moderator 

Comments or Responses

Login to post response