在sql的字符串中使用"'"，急，在线等

[sohighthesky]

如题，我想在sql中字符串拼接时使用 '
要怎么做，

[天-笑]

 ''''

[wlkjhxd]

用两个就行了，''

[肥龙上天]

select * from tb where sname like '''%'+名称+'%'''

[jinjazz]

select ''''+'123'+''''

[ws_hgo]

create table #BB(a varchar(10),b varchar(10),c int)
insert #BB values('aa','a1',3)
insert #BB values('bb','a1',4)
insert #BB values('cc','a1',3)
insert #BB values('dd','a2',5)
insert #BB values('ee','a3',6)
declare @i varchar(100)
set @i=''
select @i=@i+','+a from #BB 
select stuff(@i,1,1,'')
----------------------------------------------------------------------------------------------------
aa,bb,cc,dd,ee

(1 行受影响)

[ws_hgo]

create table #BB(a varchar(10),b varchar(10),c int)
insert #BB values('aa','a1',3)
insert #BB values('bb','a1',4)
insert #BB values('cc','a1',3)
insert #BB values('dd','a2',5)
insert #BB values('ee','a3',6)
declare @i varchar(100)
set @i=''
select @i=@i+','+a from #BB 
select stuff(@i,1,1,'')
----------------------------------------------------------------------------------------------------
aa,bb,cc,dd,ee

(1 行受影响)

[gxg353]

set @sql = 'insert into Script  (IP1,IP2,T_SQL) 
    values (''' + @IP1 + ''',''' + @ip2 + ''',''' + @T_SQL + ''')'