Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Contributor
2268 Points
511 Posts
Feb 22, 2012 07:50 AM|LINK
Try this
update dbo.Person_Test set LocalIDNumber = CONVERT(int, RAND(CHECKSUM(NEWID())) * 100000000) where LocalIDNumber is null
Muhammad Fak...
Contributor
2268 Points
511 Posts
Re: Random Unique Number generator
Feb 22, 2012 07:50 AM|LINK
Try this
update dbo.Person_Test
set LocalIDNumber = CONVERT(int, RAND(CHECKSUM(NEWID())) * 100000000)
where LocalIDNumber is null
If you feel it helps, Mark as answered so that it can help others to find solution.
For Any further questions, please contact me.