Search
 
SCRIPT & CODE EXAMPLE
 

SQL

generate a random otp in sql server

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

PREVIOUS NEXT
Code Example
Sql :: java string to sql timestamp 
Sql :: sql compare strings 
Sql :: mysql regexp_replace remove html tag 
Sql :: create database sql 
Sql :: how to show index type in postgresql 
Sql :: select where duplicate mysql 
Sql :: mysql show views 
Sql :: postgresql get today 
Sql :: describe in sqlite3 
Sql :: oracle case 
Sql :: sql date format 
Sql :: mariadb mysql root access denied 
Sql :: mysql backup table 
Sql :: sql server information_schema temp tables 
Sql :: mysql select true or false 
Sql :: select random sql 
Sql :: rename table sql server 
Sql :: postgres extract day from date 
Sql :: how to install sql in anaconda 
Sql :: primary key multiple 
Sql :: change mariadb to mysql xampp 
Sql :: sql escape quote 
Sql :: sql get inserted primary key 
Sql :: Get first name and last name from full name string in SQL 
Sql :: MySQL get all previous date record 
Sql :: postgres update with if condition query 
Sql :: SQL Less Than or Equal to Operator 
Sql :: mysql datetime with timezone offset 
Sql :: setval max id postgresql sequence 
Sql :: oracle view dependencies 
ADD CONTENT
Topic
Content
Source link
Name
8+1 =