What do we mean by Ident_Seed Sql Server Function?

 Posted by vishalneeraj-24503 on 1/20/2015 | Category: Sql Server Interview questions | Views: 585 | Points: 40
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 

Comments or Responses

Login to post response