-- =============================================

-- Retrieves records from the Account table

-- =============================================

CREATE PROCEDURE StoreCreditCard

      @theID int,

      @theCreditCard varbinary(MAX)

AS

      UPDATE Account

      SET CreditCard = @theCreditCard

      WHERE AccountID = @theID