SQLServer查询所有表所有字段包含xx的信息
发布时间：2020-12-12 15:43:49 所属栏目：MsSql教程 来源：网络整理
导读：? 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 obje
|
?
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
（编辑：李大同） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |