SQL Enlight version 1.7.2.513 released
Last week we released a new version of SQL Enlight – 1.7.2.513.
It contains just small fixes and 2 new features:
- A new layout rule ‘Miscellaneous->Keywords padding’.
The layout rule controls the padding of the main keywords in SELECT, INSERT,UPDATE and DELETE statements.
For example:
For example:
-- Keyword Padding option set to 10: SELECT ProductID , SpecialOfferID , AVG( UnitPrice ) AS 'Average Price' , SUM( LineTotal ) AS SubTotal FROM Sales.SalesOrderDetail WHERE SpecialOfferID IN( 1 , 2 , 6 , 9 ) GROUP BY ProductID , SpecialOfferID ORDER BY ProductID , SpecialOfferID DESC -- Keyword Padding option set to 0: SELECT ProductID , SpecialOfferID , AVG( UnitPrice ) AS 'Average Price' , SUM( LineTotal ) AS SubTotal FROM Sales.SalesOrderDetail WHERE SpecialOfferID IN( 1 , 2 , 6 , 9 ) GROUP BY ProductID , SpecialOfferID ORDER BY ProductID , SpecialOfferID DESC
- A new XSLT extension method ‘execute-query-plan’ which to enable support for query plan analysis.
We will describe in more detail the usage of this method in the next post.
The new version is already available for download here.
