USP_THIRDPARTYSUPPORT_ASPOSEWORDSLICENSESAVE

Parameters

Parameter Parameter Type Mode Description
@ASPOSEWORDSLICENSE varbinary IN

Definition

Copy


CREATE procedure dbo.[USP_THIRDPARTYSUPPORT_ASPOSEWORDSLICENSESAVE]
(
  @ASPOSEWORDSLICENSE varbinary(max)
)
as begin
  set nocount on;

  if exists (select top 1 1 from dbo.[THIRDPARTYSUPPORT])
    update dbo.[THIRDPARTYSUPPORT] set
      [ASPOSEWORDSLICENSE] = @ASPOSEWORDSLICENSE;
  else
    insert into dbo.[THIRDPARTYSUPPORT] (
      [ID],
      [ASPOSEWORDSLICENSE]
    ) values (
      newid(),
      @ASPOSEWORDSLICENSE
    );

  return 0;
end