Announcements
No record found.
Hello,Is there a way in CRM to do an Update like with we do in sql sesrver :
UPDATE account SET attribute1 = value1 WHEN attribute2 > value2
UPDATE account SET attribute1 = value1 WHEN
Thank you in advance.
*This post is locked for comments
No, you can do update in bulk like in SQL.
The update of record need to go through Update message.
msdn.microsoft.com/.../microsoft.xrm.sdk.iorganizationservice.update.aspx
Thanks,
Prateek
How can I do it like a bulk in sql?
CRM doesnt work is SQL way :)
So the update happens based on GUID unlike SQL where you can apply it based on any condition.
The UPDATE message will accept the GUID of the record to be updated along with attributes.
However, you can club all these UPDATE request into a single request using ExecuteMultiple. This however doesnt change the way update happens in CRM - it just reduces the number of calls from client to server.
msdn.microsoft.com/.../microsoft.xrm.sdk.messages.executemultiplerequest.aspx
You can either do it using SSIS and KingswaySoft CRM Connector, or you can create an external application, retrieve the records in an EntityCollection that match that Query Expression, and do an Update on all records.
You can update multiple records at once by using the ExecuteMultipleRequest message.
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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
JS-09031509-0 3
AS-17030037-0 2
Mark Eckert 2
