.NETJiNi@jigneshdesai.com  
  Home |  .NET<1.0 to 3.5> Forums Blogs |  Other Technologies Skip Navigation Links  | Quiz Contest   dotnetJini Training |   Software Development 
 
NEWSEQUENTIALID( )
Thursday, 03-November-2005
SQL Server 2005 introduces a new T-SQL function called NEWSEQUENTIALID() that is similar to NEWID() function to generate GUIDs. NEWSEQUENTIALID() function creates a GUID that is greater than any GUID previously generated by this function on a specified computer (i.e it generates sequentially)

SELECT NEWSEQUENTIALID() 
UNION ALL 
SELECT NEWSEQUENTIALID() 
UNION ALL 
SELECT NEWSEQUENTIALID()

results in this output:

4d6e4dbb-8706-d911-afcb-000f1f1b2c2a
4e6e4dbb-8706-d911-afcb-000f1f1b2c2a
4f6e4dbb-8706-d911-afcb-000f1f1b2c2a
Express editions of Visual Studio are going to be free
Tuesday, 08-November-2005
How to pass multiple arguments to System.Diagnostics.Process.Start
Wednesday, 16-November-2005
Bill Gates shedule to visit Banglore on December 9, 2005
Friday, 18-November-2005








   







Chat Online
 








Add URL | About ME Privacy Policy | Legal Disclaimer

Copyright (C) 2004 -2008 JigneshDesai.com. All rights reserved