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