declare @str varchar(255)='aaaa,bbbb',
@sqlstr nvarchar(255)
select @sqlstr=''''+REPLACE(@str,',',''',''')+''''
print @sqlstr
结果:select 'aaaa','bbbb'
declare @str varchar(255)='aaaa,bbbb',
@sqlstr nvarchar(255)
select @sqlstr=''''+REPLACE(@str,',',''',''')+''''
print @sqlstr
结果:select 'aaaa','bbbb'