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

2 votes246 views1 answer
Postgresql format date dd/mm/yyyy
SQL
0 vote266 views1 answer
Querry mysql by 2 columns
SQL
5 votes262 views1 answer
Sqlite alter table add column
SQL
0 vote264 views1 answer
How to query without duplicate rows in sql
SQL
0 vote264 views2 answers
Alter table add multiple columns mysql
SQL
19 votes265 views5 answers
Mysql between date range
SQL
1 vote258 views1 answer
DATE_SUB postgres
SQL
1 vote259 views1 answer
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
SQL
1 vote257 views1 answer
Load mysql dumb
SQL
0 vote251 views1 answer
Get the First and Last Word from a String or Sentence
SQL