You can pass multiple files to DSQ. As long as they are supported data files in a valid format, you can run SQL against all files as tables. Each table can be accessed by the string {N} where N is the ...

When you add the FOR JSON clause at the end of a SQL SELECT query, SQL Server will take the results, format them as JSON text, and return them to the client. Every row will be formatted as one JSON ...

ADD vCompany AS JSON_VALUE (InfoJSON, ‘ $.Company’) CREATE INDEX idx_Person_1 ON Person (vCompany) As you can see, SQL Server provides a hybrid model where you can put values from JSON either in key ...