USP_BLANKSINQUERYDEFAULT_ENABLEDISABLE
Executes the "Blanks In Query Default: Toggle" record operation.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | nvarchar(1) | IN | Input parameter indicating the ID of the record being updated. |
| @CHANGEAGENTID | uniqueidentifier | IN | Input parameter indicating the ID of the change agent invoking the update. |
Definition
Copy
create procedure dbo.[USP_BLANKSINQUERYDEFAULT_ENABLEDISABLE]
(
@ID nvarchar,
@CHANGEAGENTID uniqueidentifier
)
as
set nocount on;
begin try
update dbo.[INSTALLATIONINFO]
set [BLANKSINQUERYDEFAULT] = (case when [BLANKSINQUERYDEFAULT] = 1 then 0 else 1 end)
where [ID] = 1;
end try
begin catch
exec dbo.[USP_RAISE_ERROR];
return 1;
end catch
return 0;