USP_DATAFORMTEMPLATE_VIEW_GLOBALCHANGEPROCESSUSECURRENTAPPUSERID
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@DATALOADED | bit | INOUT | |
@GLOBALCHANGEPROCESSUSECURRENTAPPUSERID | bit | INOUT |
Definition
Copy
create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_GLOBALCHANGEPROCESSUSECURRENTAPPUSERID
(
@DATALOADED bit = 0 output,
@GLOBALCHANGEPROCESSUSECURRENTAPPUSERID bit = null output
)
as
set nocount on;
declare @VALUE as nvarchar(50) = (select dbo.UFN_APPSETTING_GET('USECURRENTAPPUSERIDFORGLOBALCHANGEPROCESS'));
select
@DATALOADED = 1,
@GLOBALCHANGEPROCESSUSECURRENTAPPUSERID = (select case when len(@VALUE) > 0 then convert(bit, @VALUE) else 0 end);
return 0;