GitHub

sql-array-functions.md

ARRAY[expr1, expr2, ...] Constructs a SQL ARRAY literal from the provided expression arguments. All arguments must be of the same type. ARRAY_APPEND(arr, expr) Appends the expression to the array. The ...
GitHub

yoavfeld/sql-to-json

This object is a generic tool to convert your sql tables to an any structured json object. the object gets a connected db client and a structure json object that describes the sql tables and the ...
Microsoft

Return an array from a SQL Stored Procedure to PowerApps (Split Method)

Author’s note: this blog has been updated with a link to the Request – Response method. Users who want to execute a SQL stored procedure in Flow can now send its resulting array into PowerApps. The ...
Microsoft

JSON in SQL Server 2016: Part 1 of 4

JSON is currently one of the most commonly used data exchange formats. Most modern services return information formatted as JSON text; web browsers use information formatted as JSON. JSON is the ...