Page History: VALUES Usage as Table Constructor - SQL Server

Compare Page Revisions

0 Current 0

« Older Revision - Back to Page History - Current Revision

Page Revision: Wed, May 31, 2023, 5:31 PM

Code Example¶

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