Obtain the id to be inserted next to the auto-increment column.

How to obtain the id to be inserted next to the auto-increment Column

How to obtain the id to be inserted next to the auto-increment Column

The Code is as follows:
Declare @ Table_name varchar (60)
Set @ Table_name = 'pay _ inputpa ';
Select so. name Table_name, -- table name
SC. name Iden_Column_name, -- auto-increment field name
Ident_current (so. name) curr_value, -- current value of the auto-increment Field
Ident_incr (so. name) incr_value, -- auto-increment field Growth Value
Ident_seed (so. name) seed_value -- seed value of the auto-increment Field
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 input parameter table name curr_value. This is the id to be inserted.