select rownum = identity(10) , i into #temp from t select * from #temp dr

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 / anand

1 Answers
6827 Views
I also Faced
E-Mail Answers

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

You need to multiply all values of a single column. How would you do that?

887

List the merits of index covering.

887

Differentiate between replication server and sql remote?

962

Tempdb is full. How would you clear it?

889

Explain bind cache?

945

What command helps you to know the process running on this port, but only su can run this command?

915

A single operation is failing to escalate?

823

Is sybase relational database?

886

What is cis and how can I use it?

1076

What is sybase used for?

957

Explain mirroring?

868

How do I open a sybase database?

979

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

846

What do you mean by asa in sybase?

993

What is sybase? What are its important features?

1020