April 24, 2011

Remove N rows affected after execution of stored procedure in SQL Server

Put SET NOCOUNT ON after the CREATE PROCEDURE. AS
It should be the first statement after the CREATE PROCEDURE. AS

CREATE PROCEDURE spGetData
(
parameters1
parameters2
)
AS
BEGIN

SET NOCOUNT ON

END

No comments:

Post a Comment