Home

Rule description

• NOCOUNT should be activated on PROCEDURE and TRIGGER definitions

Non-compliant Code Example

CREATE PROCEDURE [dbo].[GetAllProducts]  --Non compliant code (NOCOUNT is not activated on the procedure)
AS
BEGIN
    -- Insert statements for procedure here
    SELECT * From Production.Product;
END;
GO

Compliant Code Example

CREATE PROCEDURE [dbo].[GetAllProducts] 
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from interfering with SELECT statements.
    SET NOCOUNT ON;   --Compliant code (NOCOUNT is activated on the procedure)

    -- Insert statements for procedure here
    SELECT * From Production.Product;
END;
GO