By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,608 Members | 1,925 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,608 IT Pros & Developers. It's quick & easy.

NEWID()

P: n/a
Is there a limitation of using:

set @sessionID = NEWID()

would there be a simular NEWID() being generated if used in a database
application.

Eugene Anthony

*** Sent via Developersdex http://www.developersdex.com ***
Nov 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Eugene Anthony (so***********@yahoo.com) writes:
Is there a limitation of using:

set @sessionID = NEWID()

would there be a simular NEWID() being generated if used in a database
application.


It's not exactly clear what you are asking, but if I take wild guess
and the question is whether the same GUID can be generated twice, the
answer is that the likelyhood for this is negligible, 2^-128 is a
very small number.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.