XML

• Topics

  Started by

  Posts

  Last post

• how to get the node names as well as node values from xml in sqlserver

  i have an XML like:- <XML> <Provider> <providerID>1</providerID> …

  suvo.kundu

  8 replies

  12 years, 2 months ago

  By: Arthur Olcot

• XML Data Type .modify() Method in an update statement?

  I have an column of XML data type in a table. I need to change the text() node value on one elemen…

  LerxtDBA

  4 replies

  12 years, 3 months ago

  By: Ayeager78

• WITH XMLNAMESPACES y subconsultas

  hi, i have a problem with xmlnamespaces. i try to explain my problem using a little example (inform…

  benito 53825

  3 replies

  12 years, 3 months ago

  By: benito 53825

• Flex Problem

  Hey, When I try to open an MXML file: I get this message in Flex, what should I do to fix the probl…

  njdevils39

  4 replies

  12 years, 4 months ago

  By: Jeff Moden

• Construct XML data using structure shown in varchar column

  I need to construct XML from data which 'hints' at the structure of the required data but I'm strug…

  BrainDonor

  7 replies

  12 years, 4 months ago

  By: Arthur Olcot

• XML Explicit Error

  Hi, Can anyone please let me know where I am Goin wrong with this code. I am getting the following …

  Sree123

  5 replies

  12 years, 4 months ago

  By: grovelli-262555

• XML.value - I can't get it right

  Sorry for the stupid question, but I cannot figure out this thing. I'm querying an audit file with …

  Sean Pearce

  2 replies

  12 years, 5 months ago

  By: Sean Pearce

• error: Reference to an undefined name when creating schema

  trying to create a schema (sql 2008 R2) as shown but get the error Msg 2307, Level 16, State 1, Li…

  jwmott

  3 replies

  12 years, 5 months ago

  By: Arthur Olcot

• FOR XML PATH , for NULL column values

  Hi All, I need to create xml from a table. I am using FOR XML in PATH MODE. But for columns having …

  sankyverma38

  2 replies

  12 years, 5 months ago

  By: jbuys_54

• Cannot be bound error

  Hi All, Im trying to create a FOR XML statement to export each row individually in my database into…

  brendan.tate

  5 replies

  12 years, 5 months ago

  By: Gail Shaw

• The FOR XML clause is not allowed in a INSERT statement

  I'm actually posting a solution, not a question! The reason for this post is because of the work I'…

  BrainDonor

  4 replies

  12 years, 5 months ago

  By: GSquared

• How to add a specific new attribute in all elements of every node in any given xml

  Hi, In a provided xml either in @variable or xml column of a table, how to add a specific new attri…

  iBar

  3 replies

  12 years, 5 months ago

  By: Arthur Olcot

• help tweak my FOR XML EXPLICIT example?

  I'm trying to build a good-for-me to understand example of FOR XML EXPLICIT. i'm using a books onli…

  Lowell

  1 replies

  12 years, 6 months ago

  By: Arthur Olcot

• Creating XML from SQL Server 2005 - What are my options?

  Hello: I am new to SQl server. Here is my question and hope some one can help me. We have a databas…

  ucbus 92278

  16 replies

  12 years, 6 months ago

  By: Brandie Tarvin

• add element with a prefix to an existing xml using sql server

  Hi All I have this xml that I need to add element with a prefix. I need to update an existing xml …

  LeeLuv

  1 replies

  12 years, 6 months ago

  By: seth delconte