Content deleted Content added
m →Query evaluation ANSI: lang="postgresql" |
m →Generating data in T-SQL: lang="tsql" |
||
Line 707:
== Generating data in T-SQL ==
Method to generate data based on the union all
<syntaxhighlight lang="
select 1 a, 1 b union all
select 1, 2 union all
Line 716:
SQL Server 2008 supports the "row constructor" specified in the SQL3 ("SQL:1999") standard
<syntaxhighlight lang="
select *
from (values (1, 1), (1, 2), (1, 3), (2, 1), (5, 1)) as x(a, b)
| |||