[dbo].[Forum_Polls

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)
@Question	nvarchar(500)	1000
@ShowResults	bit	1
@EndDate	datetime	8
@TakenMessage	nvarchar(500)	1000
@ModuleID	int	4

SQL Script

CREATE PROCEDURE dbo.[Forum_Polls_PollAdd]
    @Question NVARCHAR(500),
    @ShowResults BIT,
    @EndDate DATETIME,
    @TakenMessage NVARCHAR(500),
    @ModuleID INT
AS
    INSERT  dbo.Forum_Polls_Polls
            (
              Question,
              ShowResults,
              CreatedDate,
              EndDate,
              TakenMessage,
          ModuleID
          )
    VALUES  (
              @Question,
              @ShowResults,
              GETDATE(),
              @EndDate,
              @TakenMessage,
          @ModuleID
          )
    SELECT  SCOPE_IDENTITY()

GO