Thursday, December 15, 2011

How to insert data to a table with single indentity column

Hai,

Its a tricky interview question mentioned post heading. Suppose we have a table named "tblTest" and it contains only one column with identity property. Then, how can i insert data to table without identity insert off?

Table :
CREATE TABLE tblTest
(
 ID smallint IDENTITY(1,1)
)

Insert Query :

INSERT INTO tblTest DEFAULT VALUES

 

No comments:

Post a Comment