USP_DATAFORMINSTANCE_GETEXCEPTIONSXML

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN

Definition

Copy



create procedure dbo.USP_DATAFORMINSTANCE_GETEXCEPTIONSXML
    @ID uniqueidentifier

as

    set nocount on;

    select EXCEPTIONSXML 
    from dbo.DATAFORMTEMPLATECATALOG 
        inner join dbo.DATAFORMINSTANCECATALOG     on DATAFORMTEMPLATECATALOG.ID = DATAFORMINSTANCECATALOG.DATAFORMTEMPLATECATALOGID
    where DATAFORMINSTANCECATALOG.ID = @ID

    return 0;