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 vote219 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
0 vote194 views1 answer
How should I pass a table name into a stored proc?
SQL
0 vote205 views1 answer
Find and replace query in wordpress\
SQL
0 vote193 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
0 vote197 views1 answer
Mysql update privileges
SQL
-1 vote193 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
5 votes237 views1 answer
Find table from column name in sql
SQL
0 vote161 views2 answers
Https://www.google.com/search?ei=bihqX_v9DJb--gTYoLH4DQ
SQL
5 votes247 views1 answer
Dbms_metadata.get_ddl table
SQL
2 votes223 views1 answer
Cannot return non-composite value from function that returns composite type
SQL