34,587
社区成员
发帖
与我相关
我的任务
分享
DECLARE @t TABLE (mcid CHAR(6))
INSERT @t SELECT 001234
SELECT * FROM @t
/*
mcid
------
1234
(1 行受影响)
*/
UPDATE @t SET mcid=right('000000' + mcid , 6)
SELECT * FROM @t
/*
mcid
------
1234
(1 行受影响)
*/
UPDATE @t SET mcid=right('000000' + RTRIM(mcid) , 6)
SELECT * FROM @t
/*
mcid
------
001234
(1 行受影响)
*/
update ××× set mcid = right('000000' + RTRIM(mcid) , 6)
if object_id('Day') is not null
drop table [Day]
go
CREATE TABLE [dbo].[Day](
[mcID] char(6)
)
go
insert into [Day]
select '1'
union all select '2'
union all select '3'
go
update [Day] set mcID = right(cast('00000' as CHAR(6)),5) + mcID
select * from [Day]
if object_id('Day') is not null
drop table [Day]
go
CREATE TABLE [dbo].[Day](
[mcID] varchar(6) COLLATE Chinese_PRC_CI_AS NOT NULL
)
go
insert into [Day]
select '1'
union all select '2'
union all select '3'
update [day] set mcid = right('000000' + mcid , 6)
select * from [Day]
/*
mcID
------
000001
000002
000003
(3 行受影响)
*/