ASE 15.5 Row Number Question

oppee · #1 (**permalink**) 04-14-11, 04:33

Hello,

Does ASE 15.5 support "Row_Number() over" clause as SQL Server?
If not is there any alternative for doing similar function in ASE. Many Thanks.

pdreyer · #2 (**permalink**) 04-14-11, 04:54

Insert into temp table with identity column

oppee · #3 (**permalink**) 04-14-11, 05:32

Thanks Pdreyer,

Do you know the syntax of select identity into a temp table in ASE?

e.g. select identity(1) as 'ROWID' , * into #tmp from #table

pdreyer · #4 (**permalink**) 04-14-11, 07:11

select ROWID=identity(int), * into #tmp from ...

oppee · #5 (**permalink**) 04-14-11, 10:08

Many Thanks pdreyer.

Internet Services

Web Development

Digital Marketing

Consumer Tech