Basics of XQuery in SQL Server 2005

declare @x xml
set @x=''
SELECT @x.query('
for $a in (1, 2, 3)
return $a')
-- result = 1 2 3

declare @x xml
set @x=''
SELECT @x.query('
for $a in
for $b in (1, 2, 3)
return $b
return $a')
-- result = 1 2 3

declare @x xml
set @x='111'
SELECT @x.query('
for $a in (xs:string( "test"), xs:double( "12" ), data(/ROOT/a ))
return $a')
-- result test 12 111

declare @x xml
set @x='

step 1


step 2

'
SELECT @x.query('
for $step in /ManuInstructions/Location[1]/Step
return string($step)
')

-- result step1