Hello Everyone,
Today i am going to show the XRMTOOLBOX tool SQL 4 CDS which allows you to use standard SQL syntax to query and manipulate your data and metadata in Dataverse and Dynamics 365.
.png?ssl=1)
Let’s gets started.
Here is the link for sql 4 cds
SQL 4 CDS tool Capabilities:
First of all many thanks to creator of this tool Mark Carrington.
As per the release notes:
Add support for XML data type and FOR XML clause.
Add support for Elastic tables
Add support for Stuff function
Add option to bypass plugins for SELECT statements
Improved error reporting for duplicated table/alias names
Improved error reporting for plugin errors
Improved efficiency of joins that can’t be translated to FetchXML
Improved error handling during bulk DML Operations
Fixed querying audit table
Fixed Collation label for metadata and virtual columns
Fixed hash joins on different collations
Fixed filtering on outer-joined solution table
Fixed multi threading error with partitioned aggregations
Fixed copying results with headers but…
Source link
More About This Author
Array
Dyn365CE26 September 2023{How to} Enable Enhanced Full Case Form in Dynamics 365 Customer Service
Dyn365CE25 September 2023Set Advisor Program Preview in Dynamics 365 CE Apps
Dyn365CE24 September 2023{How to} use Distill Web Monitor on Dynamics 365 Apps
Dyn365CE23 September 2023{How to} add custom button on the ribbon button on Dynamics 365 CE Apps using XRMTOOLBOX
