Insert data to table with only one IDENTITY column exists in table

Introduction

If we have a table with only one column which is marked as IDENTITY column, then how we will insert data to table? This scenario will be very rare. But we will see how to insert data to table with only one IDENTITY column exists.

Table Schema:

CREATE TABLE tblOnlyIdentityCol(ID INT PRIMARY KEY IDENTITY(1,1))

Insert Data to Table:

 INSERT INTO tblOnlyIdentityCol DEFAULT VALUES;
 INSERT INTO tblOnlyIdentityCol DEFAULT VALUES;
 INSERT INTO tblOnlyIdentityCol DEFAULT VALUES;

Output: 1,2,3

Select last Inserted Data: 

In order to select the last inserted value we can fetch using 

SELECT SCOPE_IDENTITY();

Output: 3

SET IDENTITY_INSERT tblOnlyIdentityCol ON ;
INSERT INTO tblOnlyIdentityCol(ID) VALUES(10)
INSERT INTO tblOnlyIdentityCol(ID) VALUES(20)
SET IDENTITY_INSERT tblOnlyIdentityCol OFF ;