- --SQL搜索字符串对应的表和字段
- declare @str varchar(100)
- set @str='aa' --要搜索的字符串
- declare @s varchar(8000)
- declare tb cursor local for
- select s='if exists(select 1 from ['+b.name+'] where ['+a.name+'] like ''%'+@str+'%'')
- print ''所在的表及字段: ['+b.name+'].['+a.name+']'''
- from syscolumns a join sysobjects b on a.id=b.id
- where b.xtype='U' and a.status>=0
- and a.xusertype in(175,239,231,167)
- open tb
- fetch next from tb into @s
- while @@fetch_status=0
- begin
- exec(@s)
- fetch next from tb into @s
- end
- close tb
- 转自:http://blog.csdn.net/wxg22526451/archive/2008/10/23/3129873.aspx
[SQL]SQL搜索字符串对应的表和字段
最新推荐文章于 2024-04-30 21:06:29 发布