sql - Auto-increment subquery in tsql select statement -

i have t-sql select statement , want auto-increment column in (that doesn't exist in database)

select dbo.a, dbo.b, dbo.c, select @d:=1; @increment:=@increment+1 d

is possible?

assuming you're using sql 2005 or later:

select dbo.a, dbo.b, dbo.c, row_number() over(order getdate()) d

to order rows returned form db. if want specify order can so:

select dbo.a, dbo.b, dbo.c, row_number() over(order dbo.a) d

for sql 2000 , before need unique value order by:

select dbo.a, dbo.b, dbo.c, (select count(*) dbo d2 d2.a <= dbo.a) d dbo

or if don't need single select:

select identity(int,1,1) id, dbo.a, dbo.b, dbo.c #temp dbo select * #temp

sql sql-server tsql sql-server-2000

Kamlesh