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 votes193 views1 answer
Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.
SQL
0 vote224 views1 answer
Sqlite unique multiple columns
SQL
0 vote184 views1 answer
Postgresql create user roles
SQL
2 votes267 views3 answers
Xampp mysql database not starting
SQL
-1 vote302 views1 answer
Brisanje dupliranih konatakata
SQL
2 votes187 views2 answers
Exec procedure pl sql
SQL
4 votes221 views1 answer
Describe table mysql
SQL
0 vote193 views1 answer
Sql pad left 0
SQL
1 vote157 views1 answer
Unique vs distinct sql
SQL
0 vote233 views1 answer
Oracle list user locked
SQL