[dbo].[Forum_Module_GetPortalID]

(local) > DotNetNuke_Community > Stored Procedures > dbo.Forum_Module_GetPortalID

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@ModuleID	int	4

SQL Script

CREATE PROCEDURE dbo.[Forum_Module_GetPortalID] ( @ModuleID INT )
AS
    DECLARE @PortalID INT

    SET @PortalID = ( SELECT    PortalID
                      FROM      dbo.Modules
                      WHERE     ModuleID = @ModuleID
                    )

    SELECT  @PortalID

GO

Uses

[dbo].[Modules]
dbo