摘要： ----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.* F 阅读全文