create proc test1 (@adsql varchar(1000)) as exec 'select * from table1 where c1 like ''%' + @adsql+'%''' go
create proc GetCondValue(@condition varchar(100)) as begin declare @re varchar(4000) set @re='' select @re=@re+','+rtrim(convalue) from CfgCondition where CHARINDEX(rtrim(CondID),@condition)>0 select stuff(@re,1,1,'') end
create proc test1 (@adsql varchar(1000)) as select * from table where 条件 like '%'+@adsql +'%'
as
exec 'select * from table1 where c1 like ''%' + @adsql+'%'''
go
as
begin
declare @re varchar(4000)
set @re=''
select @re=@re+','+rtrim(convalue) from CfgCondition where CHARINDEX(rtrim(CondID),@condition)>0
select stuff(@re,1,1,'')
end
as
select * from table where 条件 like '%'+@adsql +'%'