Previous Topic

Next Topic

Inhoudsopgave

Book Index

@@SQLStatus Vs. @@Fetch_Status

The function that retrieves the cursor fetch status is called @@SQLStatus in ASE and @@Fetch_Status in MS SQL Server. Also, the returned values differ.

@@SQLStatus

@@Fetch_Status

Description

0

0

Fetch succeeded

1

-2

Fetch did not succeed
Record moved or deleted

2

-1

End of record set