Monday, 21 March 2016

How to Generate Random Number in SQL

Ex 1:    convert(numeric(6,0),rand() * 999999) + 100000    o/p:259746

No comments: