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

0 vote141 views1 answer
Oracle exchange partition
SQL
25 votes158 views1 answer
How to update an attribute in MySQL
SQL
0 vote131 views1 answer
Mysql add comment to column
SQL
1 vote141 views2 answers
How to search date in sql query
SQL
0 vote148 views1 answer
Sql delete dastabase
SQL
0 vote131 views1 answer
How many rows affected in sqllite
SQL
1 vote132 views1 answer
T-SQL Alter the column data type
SQL
0 vote169 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
25 votes151 views4 answers
Import mysql dump command line
SQL
0 vote155 views1 answer
Snowflake drop column
SQL