SET NOCOUNT ON

[Cheryl3D]

I want to know if you SET NOCOUNT ON in a stored procedure or view, do you have to SET NOCOUNT OFF later in the stored procedure? Or is it optional? Just SET NOCOUNT ON at beginning, perform SQL task, then end it. Which is correct?

Thanks,
Cheryl

 

[swampBoogie]

The normal is to have

SET NOCOUNT ON

at the begining of a procedure. This means that messages telling how many rows that were affected by a delete/insert/update query will not be sent. There is no need to set nocount off and I don't see any connection to views.

 

[Cheryl3D]

Thanks swampBoogie:

Sorry, I added views but you are correct, views don't apply to this SET NOCOUNT ON situation.

Cheryl