Select (SQL): Difference between revisions

Revision as of 15:29, 1 October 2021

Revision as of 15:30, 1 October 2021

Line 707:

== Generating data in T-SQL ==

Method to generate data based on the union all

<syntaxhighlight lang="sqltsql">

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="sqltsql">

select *

from (values (1, 1), (1, 2), (1, 3), (2, 1), (5, 1)) as x(a, b)