摘要: ----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 阅读全文
posted @ 2011-06-14 14:29 qanholas 阅读(325) 评论(0) 推荐(0) 编辑
点击右上角即可分享
微信分享提示