VALUES Usage as Table Constructor - SQL Server

Code Example¶

with cte as (
    select * from (
    values 
         (1, 'Toyota')
        ,(2, 'Ford')
        ,(3, 'Honda')
        ,(4, 'Chrysler')
    ) as c(ModelId,DisplayName)
)
select * from cte