UFN_CMSNOTIFICATION_GETROLES

Return

Return Type
table

Parameters

Parameter Parameter Type Mode Description
@NOTIFICATIONID int IN

Definition

Copy


create function dbo.UFN_CMSNOTIFICATION_GETROLES(
    @NOTIFICATIONID int
)
returns table
as
return
(
    select 
        ID,
        CLIENTROLEID
    from
        dbo.CMSNOTIFICATIONROLE
    where
        NOTIFICATIONID = @NOTIFICATIONID
)