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?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the difference between an ltm and a repagent in sybase?

473


How would you replicate col = col + 1 in sybase?

545


What is sybase used for?

473


What are the important features of sybase?

480


explain engines?

491






What is replication server in sybase?

448


What happen when we delete the table using trigger?

487


How does partition assignment relate to transactions in sybase?

469


The secondary truncation point is on. How would you clear the logsegment?

476


How do I configure identities in sybase?

449


How would you configure burn factor in sybase?

481


How do I create a partitioned table that spans multiple devices in sybase?

388


What is the difference between natural join and equi join?

491


How can I tell the datetime my server started?

473


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

445