declare @i int set @i=112 SELECT LEFT('00000000',8-LEN(@i)) + cast(@i AS VARCHAR)
select @bmbh = '0' + cast(@total as nvarchar)
select @bmbh = '0' + cast(@total as nvarchar)
DECLARE @total INT DECLARE @bmbh NVARCHAR(10) SET @total=1 SET @bmbh = '0' + @total SET @bmbh=LEFT('000',3-LEN(@total))+CAST(@total AS NVARCHAR(1)) PRINT @bmbh
类似:
当字符串的长度大于10位时左取10位
当字符串的长度小于10位进右边用'0'字符补齐10位.
select left(string+'0000000000',10)
set @i=112
SELECT LEFT('00000000',8-LEN(@i)) + cast(@i AS VARCHAR)
DECLARE @bmbh NVARCHAR(10)
SET @total=1
SET @bmbh = '0' + @total
SET @bmbh=LEFT('000',3-LEN(@total))+CAST(@total AS NVARCHAR(1))
PRINT @bmbh