存储过程正确返回受影响的行数

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

-- =============================================
-- Author:  <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[ProcAddNews]   /*添加新闻*/
 -- Add the parameters for the stored procedure here
 @NewsTitle varchar(200),@NewsContent text,@TypeId int
   
AS
BEGIN
    --SET NOCOUNT ON;
    -- Insert statements for procedure here
 insert into TNews(NewsTitle,NewsContent,TypeId)
 values
 (
  @NewsTitle,
  @NewsContent,
  @TypeId
 )
END

 如果设置：SET NOCOUNT ON;
 

则存储过程不返回受影响的行数