<h1 id="select-data-into-json"><a aria-hidden="true" class="anchor-heading icon-link" href="#select-data-into-json"></a>Select Data into Json</h1>
<pre class="language-sql"><code class="language-sql">SELECT TOP (1000) *
  FROM [DataBase].[schema].[table] AS t
  FOR JSON PATH, ROOT('RootNode')
</code></pre>
<hr>
<ul>
<li>Reference:
<ul>
<li><a href="https://docs.microsoft.com/en-us/sql/relational-databases/json/format-query-results-as-json-with-for-json-sql-server?view=sql-server-ver15">Reference Docs</a></li>
</ul>
</li>
</ul>

Select Data into Json


The hyperfixated rabbit hole diving knowledge base that is my brain looking at technology.
