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
6913 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

What is asa ultralite in sybase?

984

Explain about sybase 365?

917

What is coalesce in sybase?

992

What do you mean by sybase iq?

941

How to change varchar(m) to varchar(n) in sybase?

1030

Can I partition any table in sybase ?

1053

What is the difference in storage type of numeric and decimal data types in sybase ?

906

What is the role of replication server in sybase?

1003

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

966

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

898

Are there any alternatives to isql in sybase?

994

Explain tds (tabular data streams).

950

Explain defncopy and it's usage?

1016

Is sybase relational database?

938

Why not max out all my columns sybase?

889