Monday, August 29, 2016
Dynamic CRM - Fetch XML with No Lock
In this post, we will review, how to write a Fetch XML with No lock implemented. This feature will enhance the execution of SQL and will be safer to be run in any environment(s). Lets review a sample SQL with no lock attribute and will follow with an example on how to using Fetch XML.
SELECT * FROM Employee WITH (NOLOCK);
The above can be implemented using Fetch XML as :