create proc GetLikeSql(@colvalue varchar(30))asdeclare @colcount intdeclare @tbname varchar(50)declare @sql varchar(8000)declare @i intset @i=1select @colcount=count(name) from syscolumns where id=object_id('tb')set @sql=N'select * from tb where 'while @i<=@colcount begin select @tbname=[name] from (select [name],row_number() over(order by [name]) row from syscolumns where id=object_id('tb')) a where row=@i set @sql=@sql+@tbname+' like ''%'+@colvalue+'%'' or ' set @i=@i+1endset @sql=substring(@sql,1,len(@sql)-3)exec (@sql)
