Raja

Raja

  • 796
  • 1.9k
  • 238.8k

How to add 0000 in row number in sql server?

Oct 28 2019 9:19 PM
Hi,
 
I want to create sequence number based on rownumber. i want to add 0000 before rownumber based on another column. how to do it in select query
 
00001
00002
00003
00004
00005
00006
00007
00008
00009
00010
00011
....
.....
00100
00001
00002 
 Like this...

Answers (1)