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 vote183 views1 answer
Mysql select row max date
SQL
0 vote175 views1 answer
Select true if exists on another table or false sqlserver
SQL
35 votes187 views5 answers
Sql alter column
SQL
1 vote198 views3 answers
Sql procedure
SQL
0 vote174 views2 answers
How do I UPDATE from a SELECT in SQL Server?
SQL
2 votes165 views2 answers
Exec procedure pl sql
SQL
0 vote164 views1 answer
SQL isnumeric DB2
SQL
0 vote170 views1 answer
Mysql config slave
SQL
25 votes212 views4 answers
Import mysql dump command line
SQL
0 vote171 views1 answer
Sql server datetime to string
SQL