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