<div>
<div class="content wysiwyg-content">
I have a @var coming in as XML<br />
<br />
I need a function to parse the variable below so I have a data row<br />
Name &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SalesSIteID<br />
Grand Vacations &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;103405<br />
<br />
<br />
DECLARE @var1 XML = '&lt;Response&gt;&lt;Name&gt;Grand Vacations&lt;/Name&gt;&lt;SalesSite<wbr />ID&gt;103405&lt;<wbr />/SalesSite<wbr />ID&gt;&lt;/Respo<wbr />nse&gt;'
</div>
</div>


I have a @var coming in as XML

I need a function to parse the variable below so I have a data row
Name                            SalesSIteID
Grand Vacations          103405


DECLARE @var1 XML = '<Response><Name>Grand Vacations</Name><SalesSiteID>103405</SalesSiteID></Response>'

MS SQL Server Parse XML

Extensible Markup Language (XML) refers to the encoding of documents such that they can be read by both machines and humans. XML documents use tags to show the beginning and end of a set of data. XML is used extensively on websites to show volumes of data, and is the default for a number of office productivity suites. This topic includes discussions of XML-related technologies, such as XQuery (the XML Query language), XPath (the XML Path language), XSLT (eXtensible Stylesheet Language Transformations), XLink (the XML Linking language) and XPointer (the XML Pointer language).

Remote access may refer to the connection to a data-processing system from a remote location, for example through a virtual private network remote desktop software, terminal emulation, or the activation of features of a business telephone system from outside the business's premises.