Description:
The uses after making the Set Nocount ON:
1. It reduces the Net work Traffic.
2. It improves the query performance.
How to include Set Nocount On in SP code?
Alter Procedure GetGenderCount
AS
set nocount on
Begin
select emp_gender,count(*) as Total From emp group by emp_gender
End
Share this link via
Or copy link