Row Constructor

Saranya Boopathi
Posted by Saranya Boopathi under Sql Server category on | Points: 40 | Views : 814
The values clause can be used as a derived table.

SELECT [Values].[Prefix] + [Values1].[Suffix] AS [Name]
, [Values].[Number]
FROM (VALUES ('a', 1),
('de', 2)) AS [Values] ( [Prefix], [Number] ),
(VALUES ('pple'),
('ttach'),
('manda')) AS [Values1] ( [Suffix] )

Comments or Responses

Login to post response