USP_APISUBSCRIPTIONKEY_GETKEY

        CREATE procedure dbo.USP_APISUBSCRIPTIONKEY_GETKEY
        (
          @APISUBSCRIPTIONKEY nvarchar(4000) = null output
        )
        as
          set nocount on

          exec dbo.USP_GET_KEY_ACCESS
          begin try
            select top 1
              @APISUBSCRIPTIONKEY = DecryptByKey(APISUBSCRIPTIONKEY)
            from dbo.APISUBSCRIPTIONKEY

            close symmetric key sym_BBInfinity
          end try
          begin catch
            close symmetric key sym_BBInfinity
          end catch