Answers for "sql server generate random number"

sql random integer

SELECT RAND();

Posted by: Guest on April-11-2021

generate a random otp in sql server

SELECT LEFT(CAST(RAND()*1000000000+999999 AS INT),5) as OTP;

Posted by: Guest on June-30-2021

Code answers related to "sql server generate random number"