SQL常用
来源:互联网 发布:输入网络密码来连接到 编辑:程序博客网 时间:2024/06/06 06:41
declare @str varchar(100)
set @str='沿线两侧公路1' --要搜索的字符串
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
deallocate tb
set @str='沿线两侧公路1' --要搜索的字符串
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
deallocate tb
- 常用sql
- 常用sql
- 常用SQL
- 常用SQL
- 常用sql
- 常用SQL
- sql常用
- SQL常用
- 常用SQL
- 常用sql
- 常用SQL
- 常用SQL
- 常用SQL
- sql 常用
- 常用Sql
- 常用sql
- sql常用
- 常用SQL
- C#核心概念--装箱和拆箱(什么是装箱和拆箱)
- uva 11198
- C++在windows下获取本地流量和网速的程序
- Combinations
- Mysql 启动失败 报错 1067
- SQL常用
- tomcat web 部署
- http://malijun.iteye.com/blog/39429
- Python 对数据库的支持
- cocos2d_粒子特效二
- eclipse 颜色主题更换
- 类似人人网 "新鲜事"(好友动态、SNS)架构
- 如何查看 ext APi
- 关于最近所想