[dbo].[Forum_Polls_AnswerAdd]
(local)
>
DotNetNuke_Community
>
Stored Procedures
> dbo.Forum_Polls_AnswerAdd
Properties
Parameters
SQL Script
Uses
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
Parameters
Name
Data Type
Max Length (Bytes)
@PollID
int
4
@Answer
nvarchar(200)
400
@SortOrder
int
4
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
[dbo].[Forum_Polls_Answers]
dbo