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?
- 1 Answers
- 6290 Views
- I also Faced
- E-Mail Answers
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 |
More Sybase Interview Questions
What does –i option do in sybase tools?
What is ceiling()?
What is open server in sybase?
What is replication server in sybase?
What is the timestamp datatype in sybase?
What is sybase used for?
How to change varchar(m) to varchar(n) in sybase?
How do I choose which tables to partition in sybase?
Can I use a named pipe to bcp/dump data out or in in sybase?
How do I add a sybase driver to sql developer?
What mandatory options are required for bcp command utility?
Explain data cache?
Categories
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
