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