A pattern to GUIDs?


go ahead, try it.

Run the newid() function 100 times.

I guarantee you that you will notice that in a guid with format 'xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx', as long as you run it in the same database on the same server, you will notice that the first character of the third "word" always remains the same.

In fact, I tried in on every SQL Server I could touch (about 6), in different databases, and it always came up as a "4".

'xxxxxxxx-xxxx-4xxx-xxxx-xxxxxxxxxxxx'

Anyone know why Anyone see any other patterns in GUIDs
Posted On: Thursday 15th of November 2012 08:26:34 PM Total Views:  65
View Complete with Replies