No announcements
Found 234040 threads
-
1 VotesFind attributes of xml nodes within a column
you can use the below method --this is just a sample table to illustrate your scenario declare @x table ( Id int, Nodes ...Answered | 2 Replies | 740 Views | Created by zimmy from germany - Wednesday, June 25, 2014 5:48 AM | Last reply by zimmy from germany - Wednesday, June 25, 2014 6:07 AM
-
0 Votes
Select xml node from attribute value
Here's a couple of examples to get you started: DECLARE @xml XML SET @xml = N'Answered | 2 Replies | 1871 Views | Created by .net.developer - Thursday, June 26, 2014 1:37 PM | Last reply by wBob - Friday, June 27, 2014 12:16 AM -
1 Votes
Comparing XML Nodes
"#text" if($jud -eq $jud1){ #judge if the childnode has the same value $node = $xml1.SelectSingleNode("//$_") while ($node -ne $null) { ...Answered | 7 Replies | 4525 Views | Created by JulianOrange - Thursday, December 18, 2014 4:28 AM | Last reply by JulianOrange - Monday, January 12, 2015 4:02 AM -
0 Votes
PowerShell and XML Attributes
What would I ask in the XML forums?Answered | 3 Replies | 8864 Views | Created by KevinBurton - Thursday, March 17, 2011 4:16 PM | Last reply by Bill_Stewart - Friday, March 25, 2011 4:40 PM -
0 Votes
xml modify appending an attribute value a string and the value of another node attibute
(@SQL)]') = 1 BEGIN SET @xml.modify('replace value of (/SCREEN/DEFINITION/FIELD[sql:variable("@i")]/SELECT/@CONDITIONS)[1] with ...Answered | 5 Replies | 1348 Views | Created by psib3r - Friday, January 26, 2018 10:23 AM | Last reply by psib3r - Monday, January 29, 2018 12:08 PM -
0 Votes
Attribute for XML PATH
select 'Update' as "@Record" for xml path('Mydata') -- Michael RysAnswered | 1 Replies | 8453 Views | Created by Mattaniah - Wednesday, September 30, 2009 6:37 PM | Last reply by M. Rys [MSFT] - Wednesday, September 30, 2009 8:41 PM -
1 Votes
Adding xsi:type explicitly in the xml node
You have two choices set the xsi:type attribute in a map or manipulate the resulting xml message.Answered | 13 Replies | 12334 Views | Created by Mohammed Ayaz Shaikh - Friday, December 10, 2010 4:43 AM | Last reply by Greg.Forsythe - Thursday, February 3, 2011 9:24 AM -
4 Votes
Select XML node value
Select-Xml ` -Path C:\file.xml ` -XPath //e:Name ` -Namespace @{e=http://www.microsoft.com/GroupPolicy/Settings} | Select-Object ...Answered | 15 Replies | 30467 Views | Created by kiwidj - Saturday, August 27, 2011 9:19 AM | Last reply by jrv - Wednesday, April 25, 2012 11:31 AM -
0 Votes
Updating Xml node in a xmltype column
Thanks but it could be better if you can help me in exact query I were trying UPDATE [PartnerAppointmentQueryResponse] Set ...Answered | 6 Replies | 4769 Views | Created by Kamran Shahid - Monday, February 14, 2011 10:08 AM | Last reply by Kamran Shahid - Monday, February 14, 2011 1:00 PM -
1 Votes
XML text node?
First i read my XML file in.Answered | 7 Replies | 3153 Views | Created by KevinBurton - Tuesday, September 10, 2013 5:28 PM | Last reply by Tim Curwick - Wednesday, September 11, 2013 5:02 PM -
1 Votes
Read value of repeating node in XML
The xpath editor returns correct value of the node.Answered | 9 Replies | 8501 Views | Created by MituD - Friday, July 15, 2011 9:55 PM | Last reply by Rohit.Sharma - Wednesday, July 20, 2011 4:07 AM -
0 Votes
Get XML node as 'text' data type
Use the .query method instead of the .value method to return XML.Answered | 5 Replies | 18917 Views | Created by Jim Conigliaro - Thursday, May 25, 2006 9:48 PM | Last reply by wBob - Tuesday, January 4, 2011 12:15 PM -
0 Votes
XML node into Variable
$assetXML = New-Object XML Next, load the XML into the variable.Answered | 6 Replies | 1285 Views | Created by James Bennett1 - Wednesday, November 12, 2014 1:26 PM | Last reply by AnnaWY - Tuesday, November 18, 2014 9:20 AM -
2 Votes
XML parse with n nodes
It is not clear to me if the node's names in the XML are always in the format of customfield<XXXX> were <XXX> is a number, Or if the node's names are ...Answered | 5 Replies | 764 Views | Created by Vick72 - Wednesday, June 10, 2015 4:22 PM | Last reply by pituach - Thursday, June 11, 2015 3:08 PM -
0 Votes
insert xml attribute question
Hi WineNCheese, Here is another XML native method to do it.Answered | 3 Replies | 1088 Views | Created by WineNCheese - Friday, June 5, 2020 8:05 PM | Last reply by Lily Lii - Monday, June 8, 2020 7:04 AM -
1 Votes
Processing XML with item nodes
Is there a way to work with XML files that contain item nodes?Answered | 4 Replies | 5591 Views | Created by EBGreen's Other Identity - Monday, August 8, 2011 5:49 PM | Last reply by EBGreen's Other Identity - Monday, August 8, 2011 7:47 PM -
1 Votes
Delete xml node c#
I can move it into a specific XML or C# forum for you if you'd like.Answered | 2 Replies | 10196 Views | Created by pra33390 - Sunday, February 27, 2011 3:36 PM | Last reply by Ed Price - MSFT - Thursday, December 22, 2011 2:13 PM -
0 Votes
Import Data from 2 XML Nodes into 1 SQL Table
Using the given scenerio for every parent node in XML you will have corresponding Child node with attributes,you can also double check by taking product ...Answered | 5 Replies | 3623 Views | Created by rhare - Tuesday, November 22, 2011 12:12 AM | Last reply by rhare - Tuesday, November 22, 2011 5:47 PM -
0 Votes
Node/attribute font grayed out for Destination Schema nodes in Mapper...
You can still do the normal functionality of the map when these nodes are grayed out.Answered | 1 Replies | 5487 Views | Created by A Sute - Friday, November 27, 2009 5:22 PM | Last reply by Ben Cline1 - Monday, November 30, 2009 5:19 AM -
2 Votes
Count XML nodes
I almost wonder if there's a problem with the XML file.Answered | 5 Replies | 25755 Views | Created by tomkr2 - Monday, February 4, 2013 9:05 PM | Last reply by tomkr2 - Wednesday, February 6, 2013 1:32 PM - Items 1 to 20 of 234040 Next ›
No announcements
