John Sansom – SQL Server DBA in the UK Rotating Header Image

Posts Tagged ‘Random Number’

Generate a random number in SQL Server

What is the best way to efficiently generate a random number in SQL Server? One of my favourite SQL Server authors, Michelle Ufford recently posted her method for generating a random number, in the post Random Number Generator in T-SQL. This got me thinking and I decided to do a little investigation of my own [...]