22,301
社区成员




DECLARE @table TABLE
(
val INT
)
INSERT INTO @table VALUES(0)
INSERT INTO @table VALUES(1)
INSERT INTO @table values(3)
SELECT *
FROM @table a,
@table b,
@table c,
@table d,
@table e,
@table f,
@table g,
@table h,
@table i,
@table j,
@table k,
@table l,
@table m,
@table n
ORDER BY a.val,b.val,c.val,d.val,e.val,f.val,g.val,h.val,i.val,j.val,k.val,l.val,m.val,n.val
DECLARE @table TABLE
(
val INT
)
INSERT INTO @table VALUES(0),(1),(3)
SELECT *
FROM @table a,
@table b,
@table c,
@table d,
@table e,
@table f,
@table g,
@table h,
@table i,
@table j,
@table k,
@table l,
@table m,
@table n
ORDER BY a.val,b.val,c.val,d.val,e.val,f.val,g.val,h.val,i.val,j.val,k.val,l.val,m.val,n.val