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 vote152 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL
6 votes243 views2 answers
Non relational database
SQL
0 vote153 views1 answer
Clone table structure mysql
SQL
0 vote145 views1 answer
SQL server select to get sum of hours
SQL
1 vote166 views1 answer
Psql human readable
SQL
1 vote157 views2 answers
How to enable error squiggles in vs code
SQL
0 vote163 views3 answers
Sql delete all except
SQL
0 vote152 views5 answers
Linq cheat sheet
SQL
0 vote212 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
0 vote208 views1 answer
Oracle temporary table
SQL