27,579
社区成员
发帖
与我相关
我的任务
分享
/*Microsoft SQL Server 2005 - 9.00.3080.00 (X64)
Sep 6 2009 09:15:46
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)*/
create table AAA(id int)
INSERT INTO AAA
SELECT 1 UNION ALL
SELECT 2 UNION ALL
SELECT 3
SELECT * FROM AAA
/*id
-----------
1
2
3
(3 行受影响)
*/
SELECT *,ROW_NUMBER() OVER (ORDER BY id) AS [NN] FROM AAA
/*id NN
----------- --------------------
1 1
2 2
3 3
(3 行受影响)*/
CREATE VIEW T_AAA
AS
SELECT *,ROW_NUMBER() OVER (ORDER BY id) AS [NN] FROM AAA
SQL text cannot be represented in the grid pane and diagram pane.