`

SQLServer如何查询所有表所有字段包含某某的信息

 
阅读更多
从系统表自动生成sql语句来运行得到结果
  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
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics