mysql搜索所有表里面包含的指定值_sql - 查询所有表中包含指定值

可以直接创建sql语句:

CREATE TABLE qResults (tName nvarchar(370), cname nvarchar(3630),[count] int)

declare @tname nvarchar(200)

declare @cname nvarchar(200)

declare @countOut nvarchar(200)

declare @sql nvarchar(max)

declare c_search cursor for

select t.name,c.name from sysobjects t inner join syscolumns c on t.id=c.id where t.type='u' and c.xtype in(56,167,175,231,239) order by t.name --xtype 这个地方限制类型为int varchar char nvarchar nchar 五种类型

open c_search

fetch next from c_search into @tname,@cname

while @@FETCH_STATUS=0

begin

set @sql=N'select @countx=COUNT(*) from '+@tname +' where [' +@cname +'] =''44'' '

print @sql

EXECUTE sp_executesql @sql,N'@countx nvarchar(200) out ', @count