USP_DATAFORMTEMPLATE_EDIT_APPLICATIONROOTURL

Parameters

Parameter Parameter Type Mode Description
@CHANGEAGENTID uniqueidentifier IN
@APPLICATIONROOTURL nvarchar(1024) IN

Definition

Copy

CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_APPLICATIONROOTURL 
(
    @CHANGEAGENTID uniqueidentifier = null,
    @APPLICATIONROOTURL nvarchar(1024)
)
as

    set nocount on;

    begin

        begin try

            update dbo.[INSTALLATIONINFO] set
                [ODATAROOTURL] = @APPLICATIONROOTURL

        end try

        begin catch
            exec dbo.USP_RAISE_ERROR
            return 1
        end catch

    end

return 0;