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 |
@UserName | nvarchar | 100 | INPUT |
Total: 2 parameter(s)
SQL
SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO CREATE PROCEDURE forums_GetForumInfo ( @ForumID int, @UserName nvarchar(50) ) AS IF @UserName IS NOT NULL SELECT ForumID = @ForumID, ForumGroupId, ParentId, Name, Description, Moderated, DaysToView, DateCreated, Active, TotalTopics = TotalThreads, SortOrder, IsPrivate = ISNULL((SELECT DISTINCT ForumID FROM PrivateForums WHERE ForumID = F.ForumID), 0), DisplayMask FROM Forums F (nolock) WHERE ForumID = @ForumID AND (ForumID NOT IN (SELECT ForumID from PrivateForums) OR ForumID IN (SELECT ForumID FROM PrivateForums WHERE RoleName IN (SELECT RoleName from UsersInRoles WHERE username = @UserName))) ELSE SELECT ForumID = @ForumID, ForumGroupId, ParentId, Name, Description, Moderated, DaysToView, DateCreated, Active, TotalTopics = TotalThreads, SortOrder, IsPrivate = 0, DisplayMask FROM Forums F (nolock) WHERE ForumID = @ForumID AND ForumID NOT IN (SELECT ForumID from PrivateForums) GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO