Sql遍历数据库set nocount onDeclare @Str varchar(50)Declare @CName varchar(50)Declare @CID varchar(20)set @str=adDeclare cur_Depart Cursor For s ...
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
*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们:
admin#shaoqun.com
(#换成@)。