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 vote114 views4 answers
Best data type to represent money in mysql
SQL
0 vote119 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL
1 vote117 views1 answer
Expression number 1 of select list is not in group by clause
SQL
2 votes164 views2 answers
Mysql compare datetime to another datetime
SQL
23 votes73 views3 answers
Mysqldump
SQL
1 vote133 views1 answer
SQl Server Versionen Releases und Build-Nummern
SQL
0 vote126 views4 answers
How to connect form to database
SQL
-1 vote116 views1 answer
MYSQL stored procedure select from
SQL
2 votes116 views1 answer
Could not find driver (SQL: select * from information_schema.tables where table_schema = francis_koopmart and table_name = migrations and table_type = 'BASE TABLE')
SQL
-1 vote128 views3 answers
MySQL shutdown unexpectedly
SQL