[dbo].[Forum_Polls_PollUpdate]
(local)
>
DotNetNuke_Community
>
Stored Procedures
> dbo.Forum_Polls_PollUpdate
Properties
Parameters
SQL Script
Uses
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
Parameters
Name
Data Type
Max Length (Bytes)
@PollID
int
4
@Question
nvarchar(500)
1000
@ShowResults
bit
1
@EndDate
datetime
8
@TakenMessage
nvarchar(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
[dbo].[Forum_Polls_Polls]
dbo