DECLARE @var XML
SET @var = '
 <AAA>
 <BBB/>
 <BBB nazov="atribut">text</BBB>
 </AAA> '
SELECT @var Ako

IF OBJECT_ID('T') IS NOT NULL DROP TABLE T
GO
CREATE TABLE T (intCol int, xmlCol xml default N'<kor><a/><prv2>222</prv2></kor>')
GO
INSERT T(intCol) VALUES (1), (2);
INSERT T(intCol,xmlCol) VALUES(2, N'<kor><a/><prv2>333</prv2></kor>');
SELECT * FROM T

DECLARE @xmlPr xml -- s premennou nejde
SET @xmlPr = (
 select * from openrowset
(bulk N'D:\MatrixAttributes.xml', single_clob)
 AS a )
SELECT @xmlPr

USE OsobaVztah;
DECLARE @xmlDoc xml
SET @xmlDoc = (SELECT * FROM Osoba FOR XML AUTO) -- , ELEMENTS XSINIL)
SELECT @xmlDoc

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

declare @x xml
set @x=''
SELECT @x.query('
for $a in (1, 2, 3)
return <a10> {$a*10} </a10>
 ')

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

 declare @x xml
set @x='<root>
 <Osoba Meno="B" />
 <Osoba />
 <Osoba Meno="A" />
</root>'
select @x
--select @x.query('<Osoba MENO="A"/>')
----<Osoba />
----<Osoba Meno="B" />

select @x.query(
 'for $osoba in //Osoba
 order by $osoba/@Meno
 return $osoba')

declare @x xml
set @x='<root>
 <Osoba Meno="A" />
  <Osoba />
 <Osoba Meno="B" />
</root>'
select T.col.query(
 'for $person in //Osoba[attribute::Meno]
order by $person/@Meno
 return $person')
 FROM @x.nodes('.') AS T(col)