Stored Procedures [dbo].[Forum_Polls_AnswerAdd]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@PollIDint4
@Answernvarchar(200)400
@SortOrderint4
SQL Script


CREATE PROCEDURE dbo.[Forum_Polls_AnswerAdd]
    @PollID INT,
    @Answer NVARCHAR(200),
    @SortOrder INT
AS
    INSERT  dbo.Forum_Polls_Answers
            (
              PollID,
              Answer,
              SortOrder
          )
    VALUES  (
              @PollID,
              @Answer,
              @SortOrder
          )
    SELECT  SCOPE_IDENTITY()

GO
Uses