Thursday, July 2, 2009

NEWSEQUENTIALID()

Creates a GUID that is greater than any GUID previously generated by this function on a specified computer.

CREATE TABLE myGUIDTable (myCol uniqueidentifier DEFAULT NEWSEQUENTIALID())

this is grate to see the id is created based on the machine id .
E.g: id created for me B0DD13B4-FB66-DE11-A148-001CC031A29A

my Physical address of my machine is 00-1C-C0-31-A2-9A

To know you ip address this will help you click here
to see your machine address type ipconfig/all
you can see physical address : that is same as the last 12 digits of your id

They introduced this to improve the performance of uniqueidentifiers when inserting

to get more information click here


0 comments:

 
Counter