Tricky Interview Question: Insert records into a table which has only one identity column

This is one of the tricky interviews. In one interview, the interviewer asks this question to my friend. He asked to write the insert script to insert a record a record into a table which has only one identity column.

Identity column: Identity column of a table is a column whose value increases automatically. The value in an identity column is created by the server. A user generally cannot insert a value into an identity column. An identity column can be used to uniquely identify the rows in the table.

See the example

I am creating a table with one identity column.

CREATE TABLE TestTable (   Id int identity(1,1)  )

Table is created successfully.

Now I am trying to insert a record into this table.

 

 
                 

For inserting the record we need to use “DEFAULT VALUES”

Let’s see the example.

   

 

See the result.