Answer: Ident_Seed is an in-built Sql Server function wich returns the
Seed value Which is defined as an
Identity Column we specify at the time of table creation.
Syntax:-
Ident_Seed('table_name');
For example:-
Select Ident_Seed('Table_Name');
It will return 1 because we have set up an Identity seed value to start from 1.But it may change.
Asked In: Many Interviews |
Alert Moderator