search something from db


DECLARE @tabname NVARCHAR(50)
DECLARE @colname NVARCHAR(50)

DECLARE mycursor CURSOR FOR
SELECT so.[name],sc.name
FROM sysobjects so
INNER JOIN syscolumns sc ON (so.id=sc.id)
WHERE so.xtype='U' AND sc.name LIKE  '%user%'
AND so.NAME NOT LIKE 'Audit%'

OPEN mycursor
FETCH NEXT FROM mycursor INTO @tabname,@colname
WHILE(@@FETCH_STATUS=0)
BEGIN
 --PRINT 'select * from '+@tabname+' where '+@colname+' like ''%IamV%'' '
 EXEC('select * from '+@tabname+' where '+@colname+' like ''%IamV%'' ')
 IF @@ROWCOUNT>0
 BEGIN
  PRINT @tabname
 END
 FETCH NEXT FROM mycursor INTO @tabname,@colname
END
CLOSE mycursor
DEALLOCATE mycursor

posted @ 2009-03-03 14:28 IamV 阅读(43) 评论(0) 编辑 收藏