Dynamics 365 Community Blogs DaxGeek Update_Recordset

Update_Recordset

Hossein.K

6,642

Like ( 0 )

Report

The update_recordset command allows the manipulation of many records in one
operation. This command speeds up database processing because of fewer calls
to the database. Review the update function using the update_recordset
command.

SalesTable salesTable;
update_recordset salesTable
setting salesName ="New Enterprises"
where salesTable.custAccount =="2001";

NOTE: You do not have to use the ttsbegin; or ttscommit; when you use the
update_recordset command, however it is recommended to consider using a
transaction when making other updates to the database at the same time.

Best Regards,
Hossein Karimi