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;
则存储过程不返回受影响的行数