declare @str varchar(100) set @str='abc001' select stuff(@str,3,1,'a')declare @str varchar(100) set @str='abc001,abd002,abs004' declare @s varchar(100),@s1 varchar(100) set @str=@str+',' while @str<>'' begin set @s=substring(@str,1,charindex(',',@str)) set @str=replace(@str,@s,'') set @s=replace(@s,',','') select @s=stuff(@s,3,1,'a') select @s1=isnull(@s1+',','')+@s end select @s1
declare @str varchar(100)
set @str='abc001'
select stuff(@str,3,1,'a')declare @str varchar(100)
set @str='abc001,abd002,abs004'
declare @s varchar(100),@s1 varchar(100)
set @str=@str+','
while @str<>''
begin
set @s=substring(@str,1,charindex(',',@str))
set @str=replace(@str,@s,'')
set @s=replace(@s,',','')
select @s=stuff(@s,3,1,'a')
select @s1=isnull(@s1+',','')+@s
end
select @s1
declare @var nvarchar(10)
set @var='abx001'
--select @var
select stuff(@var,3,1,'a')
----------
aba001(1 個資料列受到影響)
其中:
tablename为表名
colname为列名
x为你要将colname列中内容的第三位修改后的内容
n>=colname列长度-3
where语名为条件语句
。
stuff函数的使用