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 open client in sybase?

1 Answers  

What do you mean by exception log in replication?

1 Answers  

Is sybase a database? Explain.

1 Answers  

What is rollback trigger in a trigger?

1 Answers  

What do you mean by adaptive server enterprise?

1 Answers  

Explain update statistics.

1 Answers  

What are different performance tuning tools in sybase with example. How to optimize sql code in sybase server.

1 Answers   Polaris,

Compare join and subquery in performance?

1 Answers  

How do you check database space? What measures are there to increase the db space?

1 Answers  

What is this tds protocol in sybase?

1 Answers  

There is no space in file system and you need to take a back up. What will you do?

1 Answers  

Compare in and exists?

1 Answers  

For more Sybase Interview Questions Click Here
Categories