How to collect value returned by select statement in sybase if select returns multiple row of value?

Question

I have a query say "select name from books_det" ,and this query returns say 10 rows(name) , now i want to access the value of each and every row(i.e name) . How will i accomplish this in sybase?

I have tried declare @var varchar select @var=name from books_det //but this returns 10 rows i.e 10 name print @var go

This query doesn't seems to give any result. Can anyone please help ?

score 0 · Accepted Answer · answered Oct 12 '11 at 07:38

0

It seems that you need a cursor.

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15.0.sqlug/html/sqlug/sqlug768.htm

answered Oct 12 '11 at 07:38

kolchanov

2,018
2
14
32

How to collect value returned by select statement in sybase if select returns multiple row of value?

1 Answers1