Answers for "CREATE sequence number in sql query"

SQL
3

create sequence sql

CREATE SEQUENCE schema.seq_name 
	MINVALUE 1 
    INCREMENT BY 1 
    START WITH 1 
    CACHE 1000 
    ORDER;
GRANT SELECT ON schema.seq_name TO user_name;
Posted by: Guest on July-11-2021
0

generate sequence number in sql server

SELECT SeqNum= RIGHT('00000'+ CAST(1 AS VARCHAR(5)),5)
Posted by: Guest on June-23-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language