The insert_recordset statement copies data directly from one or more source tables into one destination table in one server trip. It's faster to use insert_recordset than an RecordInsertList
RecordInsertList (which is an x++ class) is useful in scenarios when you have to handle/modify the data before you insert it.
Therefore if you just want to move data from one ore more tables into one destination/table quickly, use the the insert_recordset.
But if you have to do some pre-processing before the data goes to the database you may choose RecordInsertList.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
533
Share
Report
All responses (
Answers (
