USP_DATAFORMADDINCATALOG_SETENABLED

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN
@ENABLED bit IN
@CHANGEAGENTID uniqueidentifier IN

Definition

Copy


create procedure dbo.[USP_DATAFORMADDINCATALOG_SETENABLED]
(
  @ID uniqueidentifier,
  @ENABLED bit,
  @CHANGEAGENTID uniqueidentifier = null
)
as begin
  set nocount on;

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

  update dbo.[DATAFORMADDINCATALOG] set [ENABLED] = @ENABLED, [CHANGEDBYID] = @CHANGEAGENTID where [ID] = @ID;

  return 0;
end