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?



How can i retrieve the pseudoColumn values of a table in sybase? In oracle, we can get the same as..

Answer / 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

More Sybase Interview Questions

What is replication server in sybase?

0 Answers  


What does –i option do in sybase tools?

0 Answers  


Can two tasks be assigned to the same partition in sybase?

0 Answers  


How to restore sybase database in sap?

0 Answers  


You need to remove duplicate rows from a sybase table. How would you do that?

0 Answers  






Explain procedure cache and data cache in sybase.

0 Answers  


How can we add a column to a table without altering the same?

4 Answers   BNP Paribas,


What is sybase used for?

0 Answers  


What data types does sybase support?

0 Answers  


How can I tell the datetime my server started?

0 Answers  


what is update statistics in sybase?

0 Answers  


Can you create your own sps for system wise?

0 Answers  


Categories