SQLServer查询所有表所有字段包含xx的信息

select a.name as columnname,object_name(a.id)as tablename into t from syscolumns a,

sysobjects b,

systypes c

where a.id=b.id??

and a.xtype=c.xtype

and b.xtype='u'

and c.name in('varchar','nvarchar','char','nchar','text','ntext')

and object_name(a.id)<>'t'

?

go

?

create function udf_genSQL(@tableName varchar(1000),@keyword varchar(1000))

returns varchar(8000)

as

begin

??? declare @sql varchar(8000)

??? set @sql='select * from '+@tableName +' where 1=1 '

??? select @sql=@sql+' or '+

?????? columnname +' like ''%'+@keyword+'%''' from t

??? where tablename=@tablename

??? return @sql

end

go

?

select dbo.udf_genSQL(tableName,'a') from t group by tablename

?

drop table t

drop function dbo.udf_genSQL

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!