SQL Server searches for table names and fields based on values

DECLARE @what varchar SET @what = ' lll '--the string to be searched

DECLARE @sql varchar (8000)

DECLARE tablecursor CURSOR LOCAL for select sql= ' IF EXISTS (select 1 from [' +o.name+ '] WHERE [' +c.name+ '] like '% '[E Mail protected]+ '% ') the table and field where PRINT ' is located: [' +o.name+ ']. [' +c.name+ '] ' from syscolumns c joins sysobjects o on c.id=o.id

--175=char 56=int can check the select * from Sys.types WHERE o.xtype= ' U ' and c.status>=0 and C.xusertype in (175, 239, 231, 167 )

OPEN Tablecursor

FETCH NEXT from Tablecursor to @sql while @ @FETCH_STATUS =0 BEGIN EXEC (@sql) fetch next from tablecursor to @sql END

CLOSE Tablecursor

--Delete cursor reference deallocate tablecursor

SQL Server searches for table names and fields based on values