CODE EXAMPLE FOR SQL

generate a random otp in sql server

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