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

16 votes105 views1 answer
Mssql int max value
SQL
1 vote108 views1 answer
Date_part mysql
SQL
0 vote111 views3 answers
Magento 2 order delete from db
SQL
1 vote111 views2 answers
Mysql remove first and last character from string
SQL
0 vote109 views2 answers
Oracle select
SQL
3 votes97 views2 answers
Oracle sql select all days between two dates except weekends
SQL
6 votes90 views2 answers
Return columns from table sql
SQL
0 vote127 views1 answer
SQL Server Altering Column to be Unique
SQL
10 votes106 views1 answer
All_dependencies
SQL
1 vote105 views1 answer
Mysql pretty date format
SQL