create table tb(s varchar(10)) insert into tb select 'abcde' insert into tb select '12345'update tb set s= left(s,2)+'0'+right(s,3)select * from tbab0cde 120345
declare @char varchar(20) set @char='12345' select replace(@char,substring(@char,3,1),substring(@char,3,1)+'0')
如果列里的数据比较多,是不是要写无数个select语句呢?
1, select replace(column,substring(column,3,1),substring(column,3,1)+'0')2, update table set column=left(ltrim(column),2)+'0'+right(rtrim(column),3)3, select MOD(cast(column as int),10000)*100000+MOD(cast(column as int),1000)*10000+MOD(cast(column as int),100)*100+MOD(cast(column as int),10)*10
set @s = 'adsfd'
select stuff(@s,3,0,'0')-------
ad0sfd(所影响的行数为 1 行)
insert into tb select 'abcde'
insert into tb select '12345'update tb set s= left(s,2)+'0'+right(s,3)select * from tbab0cde
120345
declare @char varchar(20)
set @char='12345'
select replace(@char,substring(@char,3,1),substring(@char,3,1)+'0')
select replace(column,substring(column,3,1),substring(column,3,1)+'0')2,
update table
set column=left(ltrim(column),2)+'0'+right(rtrim(column),3)3,
select MOD(cast(column as int),10000)*100000+MOD(cast(column as int),1000)*10000+MOD(cast(column as int),100)*100+MOD(cast(column as int),10)*10