[dbo].[Forum_Avatar_Role

[dbo].[Forum_Avatar_Role_GetAll]

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

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

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

SQL Script

CREATE PROCEDURE dbo.[Forum_Avatar_Role_GetAll] ( @PortalID INT )
AS
    SELECT  R.RoleID,
            R.RoleName,
            AR.Avatar
    FROM    dbo.Roles R
            LEFT OUTER JOIN dbo.Forum_Avatar_Role AR ON R.RoleID = AR.RoleID
    WHERE   R.PortalID = @PortalID

GO

Uses

[dbo].[Forum_Avatar_Role]
[dbo].[Roles]
dbo