Monday, 23 February 2009

How to Insert data to a table with only Identity Column

DECLARE @Table1 TABLE(
  Column1 INT IDENTITY(1,1) PRIMARY KEY
)

INSERT INTO @Table1 DEFAULT VALUES

SELECT * FROM @Table1

No comments:

Post a Comment