select rownum = identity(10) , i into #temp from t select * from #temp dr

How can i retrieve the pseudoColumn values of a table in
sybase? In oracle, we can get the same as 'ROWID'. Likewise
in sybase which one is pseudo column?

Question Posted / anand

1 Answers
6733 Views
I also Faced
E-Mail Answers

Answer Posted / anand

select rownum = identity(10) , i into #temp from t
select * from #temp
drop #temp
go

Is This Answer Correct ?

2 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to divide by zero and nulls in sybase?

903

Explain defncopy and it's usage?

906

What is asa ultralite in sybase?

864

We have lost the sa password, what can we do?

809

What is replication server in sybase?

773

Who owns sybase?

791

How does partition assignment relate to transactions in sybase?

782

How do I correct time slice -201?

865

What are triggers? Why do we use them? Diff types of triggers? What are magic tables?

878

Explain open server?

870

Is sybase open source?

821

How to implement if-then-else in a select clause in sybase?

746

What is the drawbacks of normalization?

911

Explain procedure cache?

883

How do I open a sybase database?

895