1

Topic: Select c formation of an autoincremental column

MS SQL 2008
Select c formation of an autoincremental column
Whether it is possible to make request, with numbering
Conditionally so:
Select <nnnn>, * from table
In the table there is no field nnnn
It is necessary to receive result:
nnnn remaining fields
1.............
2.............
3.............
4.............

2

Re: Select c formation of an autoincremental column

alm2;
FAQ
The fifth

3

Re: Select c formation of an autoincremental column

alm2;

ROW_NUMBER () it is supported from 2008 servers

4

Re: Select c formation of an autoincremental column

alex_p_n wrote:

alm2;

ROW_NUMBER () it is supported from 2008 servers

With 2005

5

Re: Select c formation of an autoincremental column

alex_p_n wrote:

alm2;

ROW_NUMBER () it is supported from 2008 servers

with 2005