INSERT INTO dbo_orders (cust_id, subtotal, total, PayBy, siteID, ApiEventId, ApiContactId) VALUES (,300.00,300.00,'Sagepay',1, '',''); SELECT @@IDENTITY