USP_DATAFORMTEMPLATE_PRELOAD_BATCH2TEMPLATE_2
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @BATCHTYPECATALOGID | uniqueidentifier | IN | |
| @BATCHSUPPORTSCHECKINGFORDUPLICATERECORDS | bit | INOUT | |
| @TEMPLATEPERMISSIONS | xml | INOUT | |
| @CUSTOMIZEPERMISSIONS | xml | INOUT | |
| @GLOBALNUMBERINGSCHEMEID | uniqueidentifier | INOUT |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_BATCH2TEMPLATE_2
(
@BATCHTYPECATALOGID uniqueidentifier,
@BATCHSUPPORTSCHECKINGFORDUPLICATERECORDS bit = null output,
@TEMPLATEPERMISSIONS xml = null output,
@CUSTOMIZEPERMISSIONS xml = null output,
@GLOBALNUMBERINGSCHEMEID uniqueidentifier = null output
)
as
set @TEMPLATEPERMISSIONS =
(select
ID as SYSTEMROLEID,
NAME,
2 as GRANTORDENY
from dbo.SYSTEMROLE
order by NAME
for xml raw('ITEM'),type,elements,root('TEMPLATEPERMISSIONS'),BINARY BASE64);
set @CUSTOMIZEPERMISSIONS =
(select
ID as SYSTEMROLEID,
NAME,
2 as GRANTORDENY
from dbo.SYSTEMROLE
order by NAME
for xml raw('ITEM'),type,elements,root('CUSTOMIZEPERMISSIONS'),BINARY BASE64);
select @GLOBALNUMBERINGSCHEMEID = ID
from BATCHNUMBERINGSCHEME
where ISGLOBAL = 1;
return 0;