EXEC ADO TO INSERT INTO Orders WITH REFRESH USING RETURNED DATAROW USE INSERT INTO Orders (CustomerID, OrderDate) VALUES ({CustomerID}, {OrderDate}); SELECT @@IDENTITY as OrderID END-EXEC