Tuesday, April 23, 2019

Generate Integer random number in sql server 2008 R2

select ABS(CAST(NEWID() AS binary(6)) %1000) as RandomNumber

No comments:

Post a Comment