How to generate random numbers in sql server


SELECT RandomNumber = CONVERT(VARCHAR,ABS(CHECKSUM(NEWID())))
FROM master.dbo.spt_values
ORDER BY RandomNumber

Comments

Popular posts from this blog

How to Read TOC Headings from word document using C#

List of special Characters in HTML