Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

select query

1 view
Skip to first unread message

JS

unread,
Jan 17, 2007, 1:24:56 AM1/17/07
to
Hi ,
I am an Oracle developer working on a Migration project.
I know nothing about Sybase and most of the Sybase code
has already been converted using some tool.
I came across this very basic query in Sybase

declare @email_count tinyint
select @email_count = i_no_of_emails from EmailTbl where Id = 9

There are 2 records in the EmailTbl that satisfies the condition ID= 9.
How come Sybase retrieves only one row and does not raise a Multiple
Rows fetched error or something similar to that . Because, if I run
this same query in Oralce (PL/SQL) , I will get an "exact fetch
returned multiple rows " error .
I 'll really appreciate any views on this ..

Thanks
-JS

0 new messages