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 vote224 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL
0 vote219 views1 answer
Mysql conf.d exampel
SQL
0 vote205 views1 answer
Adding primery key constraint to a column
SQL
1 vote229 views1 answer
Psql import backup file for windows
SQL
0 vote230 views1 answer
Count columns psql(PostreSQL)
SQL
0 vote217 views1 answer
Sql add calculated column
SQL
3 votes248 views3 answers
Create table in SQL Server
SQL
0 vote215 views1 answer
Mysql procedure between two tables
SQL
1 vote213 views2 answers
DROP TABLes regardless of constraints
SQL
0 vote218 views1 answer
MySQL import data from large CSV file
SQL