Activity overview
Latest activity by Chris
PIVOT
In the sample query below [object_id] and [type_desc] are underlined in green because they're unqualified. SQL Prompt does not automatically add the [p]. aliases and if I manually add them and then...
JSON_ARRAYAGG
I'm using SQL Prompt 11.0.8 on Azure SQL database, using an example from Microsoft's JSON_ARRAYAGG documentation:SELECT TOP(5) c.object_id, JSON_ARRAYAGG(c.name ORDER BY c.column_id) AS column_list...
CONCAT_WS
This is a new function in SQL Server 2017, SQL Prompt puts it in square brackets when I 'Format SQL', which causes a syntax error.