Microsoft SQL Sample Code | Random Number

Function/Script for Generating a Random Number | Azure Script

This SQL Server/Azure script/function is very useful for generating a random X Digit number.

Declare @prmDigits Int Set @prmDigits = 8 Select LEFT(SUBSTRING (RTRIM(RAND()) + SUBSTRING(RTRIM(RAND()),3,11), 3,11),@prmDigits) as RandomNumber

If you need any help implementing this function or modifications made for your needs, please get a free quote for your Microsoft SQL Development needs. 

To learn more about the WSI quoting process.