I am creating this blog mainly for my own purposes. I have been an Oracle Utilities Consultant (LODESTAR) for the last 6 years. The LODESTAR ASP framework is very poorly documented, so I will use this blog to save all my goodies and code snippets for later use.
If anybody else is getting any use out of this, please leave a comment.
Wednesday, May 23, 2012
Random value in a range
Update a value in SQL Server 2008 with a random value in a range:
ABS(CHECKSUM(NEWID())) % 300 + 110 (that will add numbers between 110 and 409
No comments:
Post a Comment