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

0 vote296 views1 answer
Get server date mysql
SQL
0 vote331 views2 answers
Unique key
SQL
0 vote297 views1 answer
Postgres in operator with comma separated values
SQL
0 vote352 views1 answer
Sql trim whitespace
SQL
3 votes308 views2 answers
Postgresql remove not null constraint
SQL
7 votes327 views3 answers
Sql set
SQL
0 vote299 views2 answers
Plan d'exécution requete oracle autotracer
SQL
0 vote317 views1 answer
Psql list rules
SQL
1 vote363 views1 answer
Sql select sum group by id laravel
SQL
0 vote315 views1 answer
Mariadb date equals to current_date plus days
SQL