I’m pleased to announce SQL 4 CDS 4.0.1 for working with your Dataverse data in SQL. This includes a number of improvements to SQL language support, error reporting and SSMS support.
When it was initially released, the TDS endpoint required you to connect on port 5558, and the SQL 4 CDS SSMS plugin only applied to connections on that port. As you can now connect to TDS endpoint on the default port, the SSMS plugin will now also activate for connections to
orgname.crm.dynamics.com as well as
The SQL 4 CDS XrmToolBox tool now accepts the
CTRL+E keyboard shortcut as well as
F5 to match SSMS.
This release fixes an error when executing a query combining aggregates, joins and the
ORDER BY <index> syntax, e.g.
SELECT name, count(*) FROM account INNER JOIN systemuser ON account.ownerid = systemuser.systemuserid GROUP BY name ORDER BY 2 DESC;
It also fixes an error when inserting values into many-to-many relationship tables, e.g.:
INSERT INTO listmember (listid, entityid) VALUES ('<guid>', '<guid>');