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
6815 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

What is the role of replication server in sybase?

946

What are table partitions? How is it different with ase 15.0 version?

875

What is the depth of triggers?

969

How do I turn off marked suspect on my database in sybase?

876

Explain data cache?

905

How do I configure identities in sybase?

851

How do I run multiple versions of sybase on the same server?

865

Explain the features of sybase.

900

Does table partitioning require user-defined segments in sybase?

782

Explain sybase sql server?

944

What is a natural key in sybase?

1027

Why place tempdb and log on low numbered devices?

829

How to check sybase database status in linux?

1011

How do the blocker processes exist internally in sybase?

896

List the merits of index covering.

884