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