Sybase - How to find row id in sybase

GeekInterview.com > Interview Questions > Database > Sybase

Go To First | Previous Question | Next Question

Sybase | Question 53 of 64

How to find row id in sybase

Total Answers and Comments: 3

Last Update: November 24, 2008 Asked by: sudipbis

Sponsored Links

Best Rated Answer

—

Submitted by: dhampack

Rowid function is not supported in ASE, it's only supported in Sybase IQ

Above answer was rated as good by the following members:
mbm52

July 09, 2008 06:28:43

SWATI_JANHAVI

Member Since: July 2008 Contribution: 2

RE: How to find row id in sybase

SELECT ROWID(M) * FROM TABLE M > IT WILL SHOW ROWID OF EVERY ROW.

Is this answer useful? Yes | No

September 03, 2008 11:45:17

kay_kannan

Member Since: September 2008 Contribution: 1

RE: How to find row id in sybase

select distinct SHORT_NAME row_id identity(10) into #tmpPosCust from #tmpPosFinal

Is this answer useful? Yes | No

November 23, 2008 23:07:48

dhampack

Member Since: November 2008 Contribution: 6

RE: How to find row id in sybase

Rowid function is not supported in ASE it's only supported in Sybase IQ

Is this answer useful? Yes | No

1 0

Overall Rating: +1

Go To Top

User Name		Remember Me?
Password

Question Bank