USP_CODETABLECATALOG_SETISSECURABLE

This procedure sets the ISSECURABLE field on the given code table.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@ISSECURABLE	bit	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



            create procedure dbo.USP_CODETABLECATALOG_SETISSECURABLE
            (
                @ID uniqueidentifier,
                @ISSECURABLE bit,
                @CHANGEAGENTID uniqueidentifier = null
            )
            as
                set nocount on;

                if @CHANGEAGENTID is null
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                update
                    dbo.CODETABLECATALOG
                set
                    ISSECURABLE = @ISSECURABLE,
                    CHANGEDBYID = @CHANGEAGENTID,
                    DATECHANGED = getdate()
                where
                    ID = @ID;