USING IDENTITY_INSERT TO INSERT IDENTITY VALUES

create table emp(id int identity(1,1), name varchar(20), dob datetime,gender bit)
go

set identity_insert emp on
insert into emp(id,name,dob,gender) values(7,'sam','01/06/1982',1)
set identity_insert emp off