Kevin Perez
Member since May 7, 2014
- Profile: /members/11889-kevin-perez.htm
- URL: http://www.dottygale.com
- Comments: 1
Recent Blog Comments By Kevin Perez
-
Seeding SQL RAND() Method With NEWID() For Per-Row Random Values (Thanks Joshua Cyr)
Posted on May 7, 2014 at 3:30 PM
The reason that this works is that Rand() is seeded with an integer. What is being returned is the first number in the series for that seed. If NewID()'s universe of returned values encapsulates all of T-SQL's Integers (from -2,147,483,648 through 2,147,483,647) then the solution provided above wil... read more »