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