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

1 vote117 views2 answers
Postgresql remote connect
SQL
0 vote131 views1 answer
How to get data from 2 database
SQL
0 vote118 views1 answer
How to check which table has data in mysql
SQL
1 vote97 views1 answer
Mysql select another database
SQL
0 vote118 views1 answer
Mysql sum with group by
SQL
8 votes109 views1 answer
Oracle search source code
SQL
2 votes135 views2 answers
Install postgresql
SQL
0 vote102 views1 answer
Opensuse stop MySQL
SQL
0 vote112 views1 answer
Like date sql server not working
SQL
4 votes123 views3 answers
Check if two date ranges overlap sql server
SQL