MB-500 · Question #372
A company implements Dynamics 365 Finance and Dynamics 365 Supply Chain Management. The company plans to perform a sales history analysis on existing customers, including their sales history and…
The correct answer is A. RecordInsertList. You can use SQL statements, either interactively or in source code, to insert one or more rows into tables that are stored in the database. insert method - Insert one row at a time. doInsert method - Insert one row at a time. insert_recordset statement - Copy multiple records…
Question
Options
- ARecordInsertList
- BRecordSortedList
- CInsert_recordset
- DdoInsert
How the community answered
(46 responses)- A43% (20)
- B13% (6)
- C35% (16)
- D9% (4)
Explanation
You can use SQL statements, either interactively or in source code, to insert one or more rows into tables that are stored in the database. insert method - Insert one row at a time. doInsert method - Insert one row at a time. insert_recordset statement - Copy multiple records directly from one or more tables into another table in one database trip. RecordInsertList.insertDatabase - Insert multiple rows at the same time in one database trip. Use this construct when you don't have to sort the data. RecordSortedList.insertDatabase - Insert multiple rows at the same time in one database trip. Use this construct when you want a subset of data from a specific table, and you want that data to be sorted in an order that doesn't currently exist as an index. RecordSortedList, RecordInsertList, and insert_recordset let you insert multiple records. By using these methods, you reduce communication between the application and the database. Therefore, you help increase performance. In some situations, record set-based operations can fall back to record-by-record operations. https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/dev-ref/xpp-data/xpp-insert https://learn.microsoft.com/en-us/dotnet/api/dynamics.ax.application.recordinsertlist https://learn.microsoft.com/en-us/dotnet/api/dynamics.ax.application.recordsortedlist
Topics
Community Discussion
No community discussion yet for this question.