04.01.2017

SQL: Row value constructor

In MS SQL Server (starting from 2008) it is possible to use a row valued constructor as a derived table. The possible scenarios are:
select distinct * from (values (1), (1), (1), (2), (5), (1), (6)) as X(a)
select * 
from (values (1, 'User1'),
             (2, 'User2'),
             (3, 'User3'),
             (4, 'User4')) AS [Users] ( [Id], [Login] )

Комментариев нет:

Отправить комментарий