DekGenius.com
Home
(current)
Dictionary
BOOKS
LYRICS
CHORD
SCRIPT & CODE EXAMPLE
Karaoke language
Search
Go
SCRIPT & CODE EXAMPLE
CODE EXAMPLE FOR SQL
generate sequence number in sql server
SELECT
SeqNum
=
RIGHT
(
'00000'
+
CAST
(
1
AS
VARCHAR
(
5
)
)
,
5
)
PREVIOUS
NEXT
Tagged:
#generate
#sequence
#number
#sql
#server
ADD COMMENT
Topic
COMMENT
Name
1+2 =
Submit