How to return multiple tables

This is the default behaviour when returning multiple tables, and is the same as setting the ResponseDataMode to "Json2".

Please note that the JSON-structure is different than Json1 (Single table)

Return multiple tables

Query

SELECT 'Hello world' as Data

SELECT 'Hello again' as Data

Output

[
    [
      {
        "Data": "Hello world"
      }
    ],
    [
      {
        "Data": "Hello again"
      }
    ]
]

Last updated: 15 oct 2015