spBulkUpdate_WorkflowRoles
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @WorkflowID | int | IN | |
| @XML | ntext | IN |
Definition
Copy
create procedure [dbo].[spBulkUpdate_WorkflowRoles]
(
@WorkflowID int,
@XML ntext
)
AS
DECLARE @idoc int
EXEC sp_xml_preparedocument @idoc OUTPUT, @XML
delete from dbo.WorkflowRoles where [WorkflowID]=@WorkflowID
insert into dbo.WorkflowRoles([WorkflowID],[ClientRolesID])
select @WorkflowID, [ID] FROM OPENXML (@idoc, '/WorkflowRoles/ClientRolesIDs/Item',1) WITH(ID int)
EXEC sp_xml_removedocument @idoc