CREATE PROCEDURE [dbo].[SetBillingLog]
(
  @userid varchar(50),
  @charid varchar(128),
  @uniqueid varchar(128),
  @amount int,
  @itemid int,
  @itemcount int
)
AS
BEGIN
  SET NOCOUNT ON;

  BEGIN TRY
    -- Insert the values into the BillingLog table
    INSERT INTO BillingLog (BuyTime, WindyCode, CharId, UniqueId, Amount, ItemId, ItemCount)
        VALUES (GETDATE(), @userid, @charid, @uniqueid, @amount, @itemid, @itemcount);

    -- Return a success message
    SELECT 'Success' AS Result;
  END TRY
  BEGIN CATCH
    -- Log the error and return an error message
    DECLARE @errorMessage varchar(4000) = ERROR_MESSAGE();
    RAISERROR(@errorMessage, 16, 1);

    -- Return an error message
    SELECT 'Error: ' + @errorMessage AS Result;
  END CATCH;
END;