Sign Up Login


  1. Categories >> Software >> Databases >> Sybase
  2. Suggest New Category

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 / ramalakshmi.ramaraj


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 coalesce in sybase?

0 Answers  

Is there a difference in storage type of numeric and decimal data types in sybase? If yes, what?

0 Answers  

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

0 Answers  

What is the depth of triggers?

0 Answers  

Explain coalesce.

0 Answers  

How do I move tempdb off of the master device?

0 Answers  

Is data insertion is fast in SYBASE IQ if we have more indexes on a table?

3 Answers   FIC,

how to do application monitoring through AutoSys?

3 Answers   Cognizant,

What is the difference between db-lib and ct-lib in sybase?

0 Answers  

How would you lock a table in sybase? What text command will you use for it?

0 Answers  

When should I execute an sp_recompile in sybase?

0 Answers  

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

0 Answers  

For more Sybase Interview Questions Click Here
Categories