For example, the following cursor returns the names of authors with the last name of Ringer. Although the cursor fetches rows successfully, the @@FETCH_STATUS is 0. Once we get to the end of the result set, @@FETCH_STATUS becomes –1: SET NOCOUNT ON DECLARE @last_name VARCHAR(20), @...
SET FEEDBACK OFF; SELECT * FROM TABLENAME -- and then rest of the queries I used SET FEEDBACK OFF in Toad app (by Quest Software) as an alternative to SET NOCOUNT ON in SQL, but it shows error and says: ORA-00922: Missing or Invalid option Is there any alte...
Generally, you should prevent rowcount messages being sent, by adding a SET NOCOUNT ON at the start of every stored procedure, trigger and dynamically executed batch. Phil Factor demonstrates, and explains the nuances and exceptions.