[dbo].[Forum_Polls_AnswerUpdate]

(local) > DotNetNuke_Community > Stored Procedures > dbo.Forum_Polls_AnswerUpdate

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@AnswerID	int	4
@PollID	int	4
@Answer	nvarchar(200)	400
@SortOrder	int	4

SQL Script

CREATE PROCEDURE dbo.[Forum_Polls_AnswerUpdate]
    @AnswerID INT,
    @PollID INT,
    @Answer NVARCHAR(200),
    @SortOrder INT
AS
    UPDATE  dbo.Forum_Polls_Answers
    SET     Answer = @Answer,
            SortOrder = @SortOrder
    WHERE   AnswerID = @AnswerID
            AND PollID = @PollID

GO

Uses

[dbo].[Forum_Polls_Answers]
dbo