identity column in sql server

1SELECT IDENT_CURRENT('Pets') AS Result;
2

1/* To explicitly supply a value for identity column*/
2/*first turn on identity_insert  set  identity_insert (Table_Name) on*/
3SET IDENTITY_INSERT (Table_Name) ON
4
5/*In the insert query specify the column's list insert into table*/
6INSERT INTO (Table_Name) (Identity_Column,col2,col3,...) VALUES (Identity_Value,val2,val3,...)
7
8/* Now set the identity_insert set off*/
9SET IDENTITY_INSERT (Table_Name) OFF