UFN_MERCHANDISEDEPARTMENT_ISDISCOUNTABLE

Returns whether or not a merchandise department is discountable.

Return

Return Type
bit

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN

Definition

Copy


create function dbo.UFN_MERCHANDISEDEPARTMENT_ISDISCOUNTABLE(@ID uniqueidentifier)
returns bit
as begin
    return (select ISDISCOUNTABLE from dbo.MERCHANDISEDEPARTMENT where ID = @ID);
end