22,181
社区成员




set @sql = 'insert into Script (IP1,IP2,T_SQL)
values (''' + @IP1 + ''',''' + @ip2 + ''',''' + @T_SQL + ''')'
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 行受影响)
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 行受影响)
select * from tb where sname like '''%'+名称+'%'''
''''