spCustomFormAutoSavedForms_AddUpdate

Parameters

Parameter Parameter Type Mode Description
@FormGuid uniqueidentifier IN
@FormData ntext IN

Definition

Copy

        create procedure dbo.spCustomFormAutoSavedForms_AddUpdate
        (
          @FormGuid uniqueidentifier,
          @FormData ntext
        )
        as

        update dbo.CustomFormAutoSavedForms
        set
          FormGuid = @FormGuid,
          FormData = @FormData
        where FormGuid = @FormGuid

        if @@ROWCOUNT = 0
        begin
          insert into dbo.CustomFormAutoSavedForms
          (
            FormGuid,
            FormData
          )
          values
          (
            @FormGuid,
            @FormData
          )
        end