csv-xml-temptable.sql

-- temp table variable

declare @tbl table (
	a varchar(2)
)

insert @tbl
select 'v0'
union all select 'v1'
union all select 'v2'

select
	*
from
	@tbl

-- in line query

select
	*
from
	(
	select [a] = 'v0'
	union all select 'v1'
	union all select 'v2'
	) t

-- xml variable

declare @xml xml
set @xml = '<a>v0</a><a>v1</a><a>v2</a>'

select
	[a] = t.c.value('.','varchar(2)')
from
	@xml.nodes('/a ') t (c)
	
-- table value constructor

select
	*
from
	(values ('v0'), ('v1'), ('v2')) v(a)