Difference between New_Id() & Rand() SQLSERVER2005

Question

How newid() Function Work in Back Ground ?

What is the difference between rand() and newid() ?

Which is more efficient?

Thanks in advance.

Answer 1

The problem with rand is that it returns the same value for all the rows for a call. newid will be different for every row. This article explains things clearly

https://web.archive.org/web/1/http://articles.techrepublic%2ecom%2ecom/5100-10878_11-6089823.html#