USP_ANNOTATION_UPDATEQUERYVIEWRELATIONSHIPS

Executes the "Notification Query View Relationships: Update" 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_ANNOTATION_UPDATEQUERYVIEWRELATIONSHIPS
(
    @ID nvarchar,
    @CHANGEAGENTID uniqueidentifier
)
as
    set nocount on

    if @CHANGEAGENTID is null
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

    exec dbo.USP_ANNOTATION_UPDATEANNOTATIONQUERIES @CHANGEAGENTID