星空网 > 软件开发 > 数据库

Sql遍历数据库

Sql遍历数据库

set nocount onDeclare @Str varchar(50)Declare @CName varchar(50)Declare @CID varchar(20)set @str='ad'Declare cur_Depart Cursor For select name,id from syscolumns where id in (Select id From sysobjects Where xtype ='U') and xtype in (select xtype from systypes where name in ( 'varchar', 'nvarchar', 'char', 'nchar','text')) order by idOpen cur_DepartFetch From cur_Depart into @CName,@CIDWhile @@Fetch_Status=0Begin  Declare @Sql nvarchar(500)  Declare @TName nvarchar(500)  Declare @Count int  set @TName=(Select name From sysobjects Where ID=@CID)  set @Sql='select @c=Count(*) from '+@TName+' WHERE PATINDEX(''%'+@Str+'%'','+@CName+')>0'  exec sp_executesql @Sql,N'@c int output',@Count output  if (@Count>0) print @TName+'  '+@CName  Fetch From cur_Depart into @CName,@CIDEndClose cur_DepartDeallocate cur_Depart

 




原标题:Sql遍历数据库

关键词:sql

sql
*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们: admin#shaoqun.com (#换成@)。

AjMall:https://www.ikjzd.com/w/1573152479508865025
阿里电商物流:https://www.ikjzd.com/w/1573152482734628865
ALDI(阿尔迪):https://www.ikjzd.com/w/1573152500186783745
AlephCRM:https://www.ikjzd.com/w/1573152500912398338
Alexa:https://www.ikjzd.com/w/1573152501621579777
Alibris:https://www.ikjzd.com/w/1573152504087486466
重庆品胜科技与星苹台达成合作 助力部队现代化后勤建设 :https://www.kjdsnews.com/a/1836523.html
回乡创业,不知道干什么,能否推荐几个农村老家创业的好项目?:https://www.vstour.cn/a/365177.html
相关文章
我的浏览记录
最新相关资讯
海外公司注册 | 跨境电商服务平台 | 深圳旅行社 | 东南亚物流