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