（3期）传递字符，查找数据库相关表及字段值

if OBJECT_ID('sp_queryCharacter','P') is not null drop proc sp_queryCharactergocreate proc sp_queryCharacter(@what varchar(800))asbeginDECLARE @sql varchar(8000) DECLARE TableCursor CURSOR LOCAL FORSELECT sql='IF EXISTS ( SELECT 1 FROM ['+o.name+'] WHERE ['+c.name+'] LIKE ''%'+@what+'%'' ) PRINT ''select ['+c.name+'],* from ['+o.name+'] where ['+c.name+'] LIKE ''''%'+@what+'%'''''''FROM syscolumns c JOIN sysobjects o ON c.id=o.id -- 175=char 56=int 可以查 select * from sys.types WHERE o.xtype='U' AND c.status>=0 AND c.xusertype IN (36,175, 239, 231, 167, 56 ) OPEN TableCursor FETCH NEXT FROM TableCursor INTO @sqlWHILE @@FETCH_STATUS=0BEGINEXEC( @sql )FETCH NEXT FROM TableCursor INTO @sqlEND CLOSE TableCursor deallocate TableCursorEndgosp_queryCharacter 'bffc43e1-6646-434e-b47d-0a32ac793b1c'