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 |
---|---|---|---|
@ForumID | int | 4 | INPUT |
@Rolename | nvarchar | 512 | INPUT |
Total: 2 parameter(s)
SQL
SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO CREATE PROCEDURE forums_AddForumToRole ( @ForumID int, @Rolename nvarchar(256) ) AS IF NOT EXISTS (SELECT ForumID FROM PrivateForums WHERE ForumID=@ForumID AND Rolename=@Rolename) AND EXISTS (SELECT ForumID FROM Forums WHERE ForumID=@ForumID) AND EXISTS (SELECT Rolename FROM UserRoles WHERE Rolename=@Rolename) BEGIN INSERT INTO PrivateForums(ForumID, RoleName) VALUES (@ForumID, @Rolename) END GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO