22,210
社区成员
发帖
与我相关
我的任务
分享
--replicate不好用的,就写死
update Nu set BIANMA=right('000000000000000000'+BIANMA,18)
update Nu set BIANMA=right(replicate('0',18)+BIANMA,18)
update Nu set BIANMA='000'+BIANMA
create table test0720(SN int,NAME varchar(4),BIANMA varchar(20))
insert into test0720
select 1,'张三',50 union all
select 2,'李四',60
update test0720 set BIANMA=right(replicate('0',5)+BIANMA,5)
select * from test0720
update Nu set BIANMA=right(replicate('0',5)+BIANMA,5)
declare @table table (SN int,NAME varchar(4),BIANMA int)
insert into @table
select 1,'张三',50 union all
select 2,'李四',60
select SN,name,BIANMA=
right(replicate('0',5)+ltrim(BIANMA),5) from @table
/*
SN name BIANMA
----------- ---- ----------
1 张三 00050
2 李四 00060
*/