Mega Code Archive
Storing the Results in a Temporary Table Using the IDENTITY() Function
<![CDATA[
4>
5> CREATE TABLE MyTable (
6> key_col int NOT NULL IDENTITY (1,1),
7> abc char(1) NOT NULL
8> )
9> INSERT INTO MyTable VALUES ('a')
10> INSERT INTO MyTable VALUES ('b')
11> INSERT INTO MyTable VALUES ('c')
12> SELECT * FROM MyTable ORDER BY key_col
13> GO
(1 rows affected)
(1 rows affected)
(1 rows affected)
key_col abc
----------- ---
1 a
2 b
3 c
(3 rows affected)
1> SELECT
2> IDENTITY (int , 1, 1) AS rownum,
3> abc
4> INTO
5> #temp
6> FROM
7> MyTable
8> ORDER BY
9> abc
10>
11> --Retrieving the Results of Using the IDENTITY() Function from the Temporary Table
12> SELECT
13> *
14> FROM
15> #temp
16> ORDER BY
17> Abc
18>
19> drop table MyTable
20> GO
(3 rows affected)
rownum abc
----------- ---
1 a
2 b
3 c
(3 rows affected)
1>
]]>