你的位置:首页 > 数据库

[数据库]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 [email protected])  set @Sql='select @c=Count(*) from [email protected]+' WHERE PATINDEX([email protected]+'%'',[email protected]+')>0'  exec sp_executesql @Sql,[email protected] int output',@Count output  if (@Count>0) print @TName+'  [email protected]  Fetch From cur_Depart into @CName,@CIDEndClose cur_DepartDeallocate cur_Depart