Search notes:

SQL Server - select statement

Selecting into variables

select
  @var = col
from
  table
where
   abc = 17049;

A subquery apparently needs an alias to be able to select from it.

The following does not work:

select * from (
  select 'x' eggs, 'y' why union all
  select 'X' eggs, 'Y' why
);

But this does:

select * from (
  select 'x' eggs, 'y' why union all
  select 'X' eggs, 'Y' why
) NOTE_THIS_ALIAS;

select is apparently also used to display the values of variables. (Compare with print).