Thursday 2 May 2013

SQL - Identity Insert

Below is a table which has one column with identity property. How do I insert values in this table without changing the identity property of the column?

CREATE TABLE TableA(ID INT IDENTITY(1,1))

Ans:INSERT INTO TableA DEFAULT VALUES

No comments:

Post a Comment