怎么写添加insert的存储过程，用的SQL server数据库

Question

怎么写添加insert的存储过程，用的SQL  server数据库

Answer 1

Create proc [dbo].[spCreateEventState]
   @EventId bigint,
   @ConfirmState smallint,
   @ProcessState smallint,
   @FeedbackState smallint,
   @ResultState smallint
AS
Begin
INSERT INTO [EventState]
           ([EventId]
           ,[ConfirmState]
           ,[ProcessState]
           ,[FeedbackState]
           ,[ResultState])
     VALUES
           (@EventId
           ,@ConfirmState
           ,@ProcessState
           ,@FeedbackState
           ,@ResultState)
END