Identity column in sql server

How to get table current identity value in sql server

SELECT IDENT_CURRENT('Pets') AS Result;

Source: database.guide

Identity column in sql server

/* To explicitly supply a value for identity column*/
/*first turn on identity_insert  set  identity_insert (Table_Name) on*/
SET IDENTITY_INSERT (Table_Name) ON

/*In the insert query specify the column's list insert into table*/
INSERT INTO (Table_Name) (Identity_Column,col2,col3,...) VALUES (Identity_Value,val2,val3,...)

/* Now set the identity_insert set off*/
SET IDENTITY_INSERT (Table_Name) OFF

Similar codes

7 votes205 views2 answers
Mysql check db size
SQL
1 vote199 views1 answer
Sql order by where condition
SQL
1 vote164 views1 answer
Sql group by error
SQL
0 vote171 views1 answer
Add column in sql server ubuntu
SQL
0 vote176 views1 answer
Forcefully delete a row in mysql which has references
SQL
0 vote175 views1 answer
Mysql autoincrement valor inicial
SQL
0 vote174 views1 answer
Oracle list subpartitions
SQL
0 vote168 views1 answer
Zsh: command not found: mysql mamp
SQL
0 vote180 views1 answer
Mysql_error replacement
SQL
0 vote178 views1 answer
Postgresql delete multiple rows
SQL