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

Question

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.

Answer 1

INSERT T DEFAULT VALUES 

Or to insert multiple rows (up to 2048 at a time using the spt_values table)

SET IDENTITY_INSERT t ON
INSERT INTO t (id) 
SELECT Number + COALESCE(IDENT_CURRENT('t'),0) + 1
FROM master.dbo.spt_values
where type='p' and number < 2048
SET IDENTITY_INSERT t OFF

Answer 2

Try:-

INSERT INTO t Values(NULL)

Answer 3

If you want to continue inserting identity values, then use

INSERT YourTable DEFAULT VALUES;

If you want to insert explicit values then you can write

SET IDENTITY_INSERT YourTable ON
INSERT INTO YourTable (id) VALUES (5);
SET IDENTITY_INSERT YourTable OFF