Another use of the LIST function
- Last UpdatedSep 29, 2022
- 1 minute read
SELECT LIST((Name + ' = ' + cast(Value as String)), ', ') "Connection Status"
FROM System..ConnectionStatus;
Reports the connection status as comma-separated list.
SELECT LIST((Name + ' = ' + cast(Value as String)), ', ') "Connection Status"
FROM System..ConnectionStatus;
Reports the connection status as comma-separated list.