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