Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
DECLARE @XmlStoredAsNvarchar nvarchar(4000) = '
<EventContext>
<eventType>Save Test Data</eventType>
<discipline>Operations</discipline>
<documentNumber>1.2.3.4</documentNumber>
<documentVersion>1.0</documentVersion>
<sectionNumber>1.2.1.1</sectionNumber>
<sectionName>Test section: XML Test</sectionName>
<tableIdentifier>1</tableIdentifier>
<objectType>Object</objectType>
<objectTag>1.2.3.4</objectTag>
<rowIndex>10</rowIndex>
<testColumns>
<testColumn Index="3" Type="Choice List">
<columnName>Pass / Fail</columnName>
<oldValue />
<newValue>Pass</newValue>
</testColumn>
<testColumn Index="4" Type="Test Value">
<columnName>Bug #</columnName>
<oldValue> </oldValue>
<newValue> N/A</newValue>
</testColumn>
<testColumn Index="5" Type="Attachment">
<columnName>Attachment</columnName>
<oldValue>N/A</oldValue>
<newValue>N/A</newValue>
</testColumn>
<testColumn Index="6" Type="Issue">
<columnName>Deviation #</columnName>
<oldValue>N/A</oldValue>
<newValue>N/A</newValue>
</testColumn>
</testColumns>
<operatingMode>N/A</operatingMode>
</EventContext>';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.