TO INSERT USE

     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