All Questions
Tagged with sql-server-2005 xml
339
questions
1
vote
0
answers
58
views
XML Parsing in SQL
I have to parse the below xml query
DECLARE @xml XML,
@Columns VARCHAR(MAX)
set @xml='<d><record1><columnA>1</columnA><columnB>as</columnB><columnC&...
1
vote
2
answers
78
views
Transform XML record to table
I have XML data in table "sample" column name "xmlrec" that looks like:
<row id='1'>
<c1>rec1</c1>
<c2>a</c2>
<c2>b</c2>
<c2>c</c2>
</row&...
1
vote
1
answer
885
views
Invalid Character on XML generated by SQL
I need to generated an xml to load on an internet site, from my SQL2005 DB. All work fine, but when the file is loaded on the webservice that need it, I've this error:
'.', hexadecimal value 0x00, ...
2
votes
0
answers
2k
views
XML AUTO queries return derived table references in 90 or later compatibility modes
I am currently performing SQL server migration from 2005 to 2012. As the first step, I generated DMA report and observed that most of the Procedures that use XML Auto are part of that report.
MSDN ...
2
votes
1
answer
60
views
Convert XML to table SQL Server 2005
I wonder how I can read a XML data and transform it to a table in T-SQL?
For example:
<t1>
<t2>
<val>Opel</val>
<t3>Merriva</t3>
<...
-1
votes
1
answer
37
views
Creating XML in T-SQL
I have a little trouble. How I can make a root node for XML file in T-SQL like this?
<Root xmlns="http://www.bla-bla.org"
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http:/...
4
votes
2
answers
523
views
When using FOR XML AUTO in SQL Server: how do I remove empty elements from nested elements when LEFT OUTER JOIN'ing
[edit]: added RAW test and better sample code
I need to generate XML for a legacy application running SQL Server 2005, and I hope to use the FOR XML function.
I can not, however, seem to get rid of ...
0
votes
0
answers
189
views
SQL Server 2005 Concatenate XML result and Save to file
I've this code that show me separate results for each customer I fetch. I'm searching a way to concatenate that result and make one result finish to start back again with the other bloc xml result.
...
0
votes
1
answer
43
views
Should we convert left side operand of xml while comparing?
This link https://learn.microsoft.com/en-us/sql/t-sql/xml/exist-method-xml-data-type has this code:
declare @x xml;
declare @f bit;
set @x = '<root Somedate = "2002-01-01Z"/>';
set @f = @...
1
vote
1
answer
306
views
Is it possible to manipulate xml in a column?
I have a table:
create table foo (id int, reportDef xml)
Column reportDef contains a long xml string.
<Report>
<Criterias>
<Criteria name="Date Range">...</Criteria>
...
1
vote
1
answer
80
views
How to get element values from an XML column?
I have the XML below in a column. I need to get to \Report\Criterias\Criteria (where name="Advertisers")\Elements\Element(where name="ListViewAvailable"). From here I need to list all the numbers ...
1
vote
1
answer
51
views
SQL Server 2005 - Nested XML
I used this question/answer as a starting point. SQL Server : nesting elements with FOR XML PATH
I'm trying to get to this output.
<Account ExID="Customer Numer 1">
<AccountData>
<...
1
vote
1
answer
184
views
Any Linux SQL Server client (command line) which supports XML formatting?
I have to launch some batch queries from a Red Hat Server against SQL Server 2005 and I need to format the results in an XML file. I have installed msodbcsql and unixODBC in my red hat server and I ...
3
votes
3
answers
99
views
XML column compare in SQl server 2005
I want to compare two XML columns with multiple rows in SQL Server 2005.
Table structure is as below
CREATE TABLE [dbo].[UpdationLog](
[LogID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
...
1
vote
1
answer
1k
views
VB.net how to create table using xml and displaying the table on the webpage
Can somebody please help me to amend this code because i tried running but the table didnt appear on the page. I'm new to XML and somebody gave me this snippet saying that XML coding is more reliable ...