Stored Procedures [dbo].[Forum_Polls_PollUpdate]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@PollIDint4
@Questionnvarchar(500)1000
@ShowResultsbit1
@EndDatedatetime8
@TakenMessagenvarchar(500)1000
SQL Script


CREATE PROCEDURE dbo.[Forum_Polls_PollUpdate]
    @PollID INT,
    @Question NVARCHAR(500),
    @ShowResults BIT,
    @EndDate DATETIME,
    @TakenMessage NVARCHAR(500)
AS
    UPDATE  dbo.Forum_Polls_Polls
    SET     Question = @Question,
            ShowResults = @ShowResults,
            EndDate = @EndDate,
            TakenMessage = @TakenMessage
    WHERE   PollID = @PollID

GO
Uses