The Tech Pursuit
The Dev Shelf
Pages
Home
Interview Questions
About Me
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment