ASPForums.Net RSS Feedhttp://www.aspforums.net/Handlers/RSS.ashxLatest additions to the content that appears on ASPForums.Net(c) 2019 www.aspforums.com. All rights reserved.Generate 5 digit random numbers in SQL Server<p>Hi <a class="username" rel="nauna"> nauna</a>,</p> <p>Refer below query.</p> <pre class="brush: sql">SELECT CONVERT(NUMERIC(12,0),RAND() * 99999) + 10000 Code</pre> <p>&nbsp;</p>https://www.aspforums.net:443/Threads/188667/Generate-5-digit-random-numbers-in-SQL-Server/https://www.aspforums.net:443/Threads/188667/Generate-5-digit-random-numbers-in-SQL-Server/Wed, 10 Oct 2018 02:22:47 GMT