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

Given a table which contains some rows with duplicate keys, how would you remove the duplicates?

0 Answers  

What mandatory options are required for bcp command utility?

0 Answers  

Explain tds (tabular data streams).

0 Answers  

How to remove row affected and dashes?

0 Answers  

How can I improve throughput in sybase?

0 Answers  

What is rollback trigger in a trigger?

0 Answers  

can i gat any proper material for sybase if possible plz let me know balaji.cc1@gmail.com

2 Answers  

Can I run any transact-sql command on a partitioned table in sybase?

0 Answers  

How to pad with leading zeros an int or smallint in sybase?

0 Answers  

How can set the multipal database ?

0 Answers   CitiGroup,

Is sybase owned by sap?

0 Answers  

Is there any advantage of last_name varchar(50) over this last_name varchar(255)?

0 Answers  

For more Sybase Interview Questions Click Here
Categories