Navigation

	Home Page
	Index
	All Pages

Contributor Links

	Create a new Page
	Administration
	File Management
	Login/Logout
	Your Profile

Other Wiki Sections

Software

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