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)
)

In practical these kind of tables will not come. But for improving our skills we need to know. We need to use DEFAULT VALUES keyword to insert the value. Since it is the identity columm we can't insert manually as in option 4. Option 1 and option 3 are wrong synatx.