Get the next id_mssql that will be inserted in the self-added column

Copy Code code as follows:

DECLARE @Table_name varchar (60)
Set @Table_name = ' Pay_inputpay ';
Select so.name table_name,--table name
Sc.name Iden_column_name,--Self-added field name
Ident_current (So.name) Curr_value,--self-added field current value
IDENT_INCR (So.name) Incr_value,--Self-increasing field growth value
Ident_seed (So.name) Seed_value--Self-increasing field seed value
From sysobjects so
Inner Join syscolumns SC
On so.id = Sc.id
and ColumnProperty (sc.id, Sc.name, ' isidentity ') = 1
Where Upper (So.name) = Upper (@Table_name)
--@Table_name is the passed-in parameter table name Curr_value This is the ID to be inserted