title: How to create table with multiple rows and columns using only SELECT clause (i.e. using SELECT without FROM clause)
body: <p>I know that in SQL Server, one can use SELECT clause without FROM clause, and create a table with one row and one column </p>
  
  <pre><code>SELECT 1 AS n;
  </code></pre>
  
  <p>But I was just wondering, is it possible to use SELECT clause without FROM clause, to create </p>
  
  <ol>
  <li><p>a table with one column and multiple rows</p></li>
  <li><p>a table with multiple columns and one row</p></li>
  <li><p>a table with multiple columns and multiple rows</p></li>
  </ol>
  
  <p>I have tried many combinations such as </p>
  
  <pre><code>SELECT VALUES(1, 2) AS tableName(n, m);
  </code></pre>
  
  <p>to no success.</p>