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