Script to Get Increment Values of specific Table.

Vishalneeraj-24503
Posted by Vishalneeraj-24503 under Sql Server category on | Points: 40 | Views : 192
SELECT IDENT_INCR(TABLE_NAME) AS Incremented_Value,
TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE OBJECTPROPERTY(OBJECT_ID(TABLE_NAME),'TableHasIdentity') = 1
AND TABLE_TYPE = 'BASE TABLE' and
TABLE_NAME = 'Table_Name';

Comments or Responses

Login to post response