What do we mean by NEWSEQUENTIALID() function in Sql Server?

 Posted by vishalneeraj-24503 on 10/7/2014 | Category: Sql Server Interview questions | Views: 1577 | Points: 40
Answer:

As name suggests,NEWSEQUENTIALID() function generates the unique identifier values sequentially.
In other words,we can say that,a NEWSEQUENTIALID() function creates the GUIDs greater than the previously generated GUIDs,since the last restart of the system,because after restarting the system the next NEWSEQUENTIALID can be started from the lower range.

Syntax:-
create table dummy 

(
id uniqueidentifier default newsequentialid()
not null primary key clustered,
sequence int
);


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response