< Return to Feed
Mike Matthes
08.29.2016

SQL Server - XML Query

If you have an XML field in SQL Server and would like to query it, here is example syntax.

select distinct CarType
from
(select convert(varchar, DataXml.query('/Car/Detail/CarType/text()')) CarType
from CarInventory) t

< Return to Feed