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

Comments

Popular posts from this blog

Parse XML to dynamic object in C#

C# Crop white space from around the image