字符串找字段和表

?

----DROP TABLE #t

--SELECT ROW_NUMBER   ( )    OVER( PARTITION BY tid ORDER BY tablename  ) cid,*

 

--into #t

--FROM

 

--(

--SELECT TOP 100 PERCENT DENSE_RANK   ( )    OVER( ORDER BY a.name  ) tid,

--       a.name AS tablename,

--       d.name AS columnname,

--       d.cname AS type

        

--FROM   sysobjects a

--       JOIN (SELECT c.name AS cname,b.*  FROM  syscolumns b JOIN systypes c ON b.xtype=c.xusertype) d

--            ON  a.id = d.id

--WHERE  a.xtype = 'U'

--ORDER BY

--       a.name

 

--) result

 

--WHERE TYPE IN ('char','varchar','nchar','nvarchar')

  

 

SET NOCOUNT ON 

--SELECT *  FROM #t

DECLARE @t TABLE (res VARCHAR(max))

 

DECLARE @tid INT

SELECT @tid = MAX(tid)

FROM   #t

 

DECLARE @tidN INT

SET @tidN = 1

 

WHILE (@tidN < = @tid)

BEGIN

    DECLARE @cid    INT

    DECLARE @tname  VARCHAR(60)

    DECLARE @cname  VARCHAR(60)

    SELECT @cid = MAX(cid)

    FROM   #t

    WHERE  tid = @tid 

     

    DECLARE @cidN INT

    SET @cidN = 1

     

    SELECT @tname = tablename

    FROM   #t

    WHERE  tid = @tidn

     

    WHILE (@cidN <= @cid)

    BEGIN

         

         SELECT   

           @cname = columnname 

    FROM   #t

    WHERE  tid = @tidn

           AND cid = @cidn

         

        PRINT CAST(@tidn AS VARCHAR) + '    ' + CAST(@cidN AS VARCHAR) +   '    ' +@tname +  + '    ' + @cname

         

        INSERT @t

        exec  ('select  '+''''+@tname+'_' +@cname+''''+' from  '+@tname+' where  '+@cname+'=''FF''')

         

        SET @cidn = @cidn + 1

    END

     

    SET @tidN = @tidN + 1

END

 

 

SELECT *   FROM  @t t