Union All,该如何解决

2012-05-27

Union AllUnion Allcreate Viewasselect col from t1 union all select col from t2怎么加一个自增列呢？请

Union All
Union All
create View
as
select col from t1 union all select col from t2

怎么加一个自增列呢？
请注意sql2000 这里是。

[解决办法]
CREATE VIEW 没有加自增列的。
SELECT ID=IDENTITY(INT,1,1),. INTO #T

[解决办法]
union后的东东放入临时表用吧！

SQL code

select *,id = identity(int,1,1) into #tbfrom(    select .. from tb1    union all    select .. from tb2)t
[解决办法]
CREATE VIEW  
AS
SELECT * FROM
(SELECTcol ,
    (SELECT COUNT(*) FROM  
(SELECT col FROM t1 UNION ALL SELECT col FROM t2) AS A2  
WHERE A2.col<A1.col) AS RANK
 FROM (SELECT col FROM t1 UNION ALL SELECT col FROM t2) AS A1) AS B
ORDER BY RANK
[解决办法]
在2000环境下验证通过.
SQL codeCREATE VIEW ASSELECT * FROM    (SELECT    col ,            (SELECT COUNT(*) FROM                 (SELECT col FROM t1 UNION ALL SELECT col FROM t2) AS A2                 WHERE A2.col<A1.col) AS RANK     FROM (SELECT col FROM t1 UNION ALL SELECT col FROM t2) AS A1) AS BORDER BY RANK