Stored Procedure Properties
Name | Value |
---|---|
Owner | dbo |
Created | 2004-05-31 |
Startup | False |
Encrypted | False |
Creation Options
Name | Value |
---|---|
QUOTED_IDENTIFIER | OFF |
ANSI_NULLS | OFF |
Parameters
Name | DataType | Length | Type |
---|---|---|---|
@Name | nvarchar | 200 | INPUT |
@Description | nvarchar | 6000 | INPUT |
@ForumGroupId | int | 4 | INPUT |
@Moderated | bit | 1 | INPUT |
@DaysToView | int | 4 | INPUT |
@Active | bit | 1 | INPUT |
Total: 6 parameter(s)
SQL
SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO CREATE PROCEDURE forums_AddForum ( @Name nvarchar(100), @Description nvarchar(3000), @ForumGroupId int, @Moderated bit, @DaysToView int, @Active bit ) AS -- insert a new forum INSERT INTO Forums (ForumGroupId, Name, Description, Moderated, DaysToView, Active) VALUES (@ForumGroupId, @Name, @Description, @Moderated, @DaysToView, @Active) GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO