declare @cloumns varchar(40)
declare @tablename varchar(40)
declare @str varchar(40)
declare @counts int
declare @sql nvarchar(2000)
declare @dataBaseName varchar(40)
declare @sqlDB varchar(40)
declare databaseCursor Cursor For
SELECT name as dataBaseName from Master..SysDatabases
Open databaseCursor
Fetch next From databaseCursor Into @dataBaseName
While(@@Fetch_Status = 0)
Begin
set @sqlDB = ' use '+ @DataBaseName
exec(@sqlDB)
declare MyCursor Cursor For
Select a.name as Columns, b.name as TableName from syscolumns a,sysobjects b,systypes c
where a.id = b.id
and b.type = 'U'
and a.xtype=c.xtype
and c.name like '%char%'
set @str='字符串'
Open MyCursor
Fetch next From MyCursor Into @cloumns,@tablename
Whil