UFN_TIMEZONEENTRY_ACTIVE

Returns whether or not a time zone is active

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@TIMEZONEENTRYID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_TIMEZONEENTRY_ACTIVE(
    @TIMEZONEENTRYID as uniqueidentifier
    )
returns bit
with execute as caller
as begin
    declare @ACTIVE bit

    select
        @ACTIVE = ACTIVE
    from
        dbo.TIMEZONEENTRY
    where
        ID = @TIMEZONEENTRYID        

    return @ACTIVE
end