title: SQL TABLE to JSON without SQL Column Information
body: <p>I am trying to Parse Table data into JSON and in the process want to skip the Table Column Names in the Post conversion to JSON. Below is the sample Snippet.</p>
  <pre><code>DECLARE @table1 TABLE (k1 nvarchar(max), v1 nvarchar(max))
  
  -- Note k1 is unique
  INSERT INTO @table1 (k1,v1) VALUES( 'Apple', 'One')
  INSERT INTO @table1 (k1,v1) VALUES( 'Banana', 'Two')
  INSERT INTO @table1 (k1,v1) VALUES( 'Orange', 'Three')
  
  SELECT k1, v1 FROM @table1
      FOR JSON PATH, WITHOUT_ARRAY_WRAPPER
  
  --output: {&quot;k1&quot;:&quot;Apple&quot;,&quot;v1&quot;:&quot;One&quot;},{&quot;k1&quot;:&quot;Banana&quot;,&quot;v1&quot;:&quot;Two&quot;},{&quot;k1&quot;:&quot;Orange&quot;,&quot;v1&quot;:&quot;Three&quot;}
  -- Expected: {&quot;Apple&quot;,&quot;One&quot;},{&quot;Banana&quot;,&quot;Two&quot;},{&quot;Orange&quot;,&quot;Three&quot;}
  </code></pre>
  <p>Appreciate direction!</p>