In SQL Server, how can I insert data into a table that has just one column which is of identity type

Posted by Yousui on Stack Overflow See other posts from Stack Overflow or by Yousui
Published on 2010-06-09T08:48:50Z Indexed on 2010/06/09 8:52 UTC
Read the original article Hit count: 168

In SQL Server, how can I insert data into a table that has just one column which is of identity type? Such as insert into the following table t. How can I write the insert statement?

CREATE TABLE t
(
    id INT IDENTITY(1, 1) PRIMARY KEY
)

Great thanks.

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about sql-server-2005