declare @seqno as varchar(20)
set @seqno='20'
set @seqno=right('0000'+@seqno ,4)
print @seqno
MS SQL 字段前面补0
于 2024-08-13 16:40:01 首次发布
declare @seqno as varchar(20)
set @seqno='20'
set @seqno=right('0000'+@seqno ,4)
print @seqno