34,593
社区成员
发帖
与我相关
我的任务
分享
select * from tablename where (a like '%1%') or (b like '%1%') or (c like '%1%')
declare @a varchar(8000)
declare @b varchar(8000)
set @b = 'select * from tablename where '
select @a=isnull(@a+'or ('+[name] + ' like ''%1%'' ) ','') from syscolumns where id = object_id('tablename ')
set @b =@b+substring(@a,3,len(@a)-2)
exec (@b)
select * from tb
where charindex('1', a)>0 or charindex('1', b)>0 or charindex('1', c)>0