遍历数据所有表行， 是否有敏感字段

 

declare @tableName nvarchar(100),@tableId nvarchar(100)
declare @columnName nvarchar(100)
declare @cmd nvarchar(1000)
declare mycursor cursor  for select id,[name] from sysobjects  where xtype='U' and crdate'2009-12-01'
 open mycursor
 fetch next from mycursor into @tableId ,@tableName
 while @@fetch_status=0
  Begin
   declare mycursor2 cursor  for select [name] from  syscolumns where id=@tableId
    open mycursor2
    fetch next from mycursor2 into @columnName
     while @@fetch_status=0
      Begin
       set @cmd='select 1 from '+@tableName+' WHERE '+'['+@columnName+']'+' LIKE ''%口交%'''
       exec(@cmd)
       if @@rowcount>0
        Begin
         print @tableName
         print @columnName
         break;
        End
       fetch next from mycursor2 into @columnName
      END 
    close mycursor2   
    deallocate mycursor2
   fetch next from mycursor into @tableId ,@tableName  
  End
close mycursor
deallocate mycursor