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 vote270 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
1 vote282 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL
0 vote261 views1 answer
See Foreign Key
SQL
2 votes285 views2 answers
Calculate percentage in sql
SQL
0 vote273 views1 answer
Sql tablo hangi sp de
SQL
22 votes289 views3 answers
Year format in date mysql
SQL
0 vote271 views1 answer
Sql count matching group by
SQL
0 vote269 views1 answer
Mysql query to check record exists in database table or not
SQL
0 vote281 views3 answers
Fetlife
SQL
0 vote254 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL