No announcements
-
0 VotesWelcome message and some guidelines
Welcome dear seeker of XML knowledgePlease take some time to read this welcome message that can help you find your answer quicker.Please take a look at previous postings to see whether your question ...Sticky | 3 Replies | 49344 Views | Created by MRys - Friday, November 4, 2005 8:20 PM | Last reply by mafsar09 - Tuesday, February 12, 2013 3:53 PM
-
0 Votes
Creating XML with Namespaces and displaying only on root element
Hello, I have a sql statement that outputs the following XML <rsm:CrossIndustryDocument ...Unanswered | 7 Replies | 504 Views | Created by XMLuser007 - Tuesday, August 27, 2019 1:46 PM | Last reply by Yitzhak Khabinsky - Tuesday, September 3, 2019 1:04 PM -
1 Votes
SQL server XML problem
Hi guys, i need some help i got this XML DECLARE @xml XML;SELECT @xml = (SELECT TOP(1) codigo, Numero, fecha, transportista, ...Answered | 1 Replies | 333 Views | Created by Antonioll - Wednesday, August 28, 2019 3:28 PM | Last reply by Yitzhak Khabinsky - Wednesday, August 28, 2019 3:37 PM -
0 Votes
Create Table from BCP Formatted File
I have a number of xml based table files that were generated by BCP and TXT files containing data for those tables. How do I create tables in SQL Server using the .XML file and then ...Unanswered | 7 Replies | 469 Views | Created by MikeGanem2 - Thursday, August 22, 2019 10:14 PM | Last reply by Yitzhak Khabinsky - Friday, August 23, 2019 6:58 PM -
0 Votes
reading xml data
I have many similar tables with many common fields but each also has some unique fields I figure to do a "select * from table for xml raw" for each table into a variable, ...Answered | 10 Replies | 511 Views | Created by berli - Wednesday, August 21, 2019 7:22 AM | Last reply by Yitzhak Khabinsky - Thursday, August 22, 2019 2:34 PM -
1 Votes
SQL Deadlock Troubleshooting and Statistics
100) I'm trying to troubleshoot the causes of these deadlocks, i noticed that many deadlocks occur at the same tables, I'm a newbie in Database Administrator so i don't ...Unanswered | 2 Replies | 441 Views | Created by Ultramation - Monday, August 12, 2019 9:09 AM | Last reply by Tom Phillips - Monday, August 12, 2019 5:51 PM -
0 Votes
Save SQL Result in XML File on drive
Hi All, How could I save query XML result into physical file on hard drive? I am preparing multiple files having 500 records each. I tried following ...Proposed | 49 Replies | 1157 Views | Created by tams1151 - Wednesday, July 31, 2019 10:17 PM | Last reply by Yitzhak Khabinsky - Tuesday, August 6, 2019 1:48 AM -
0 Votes
How to get field and value from a given string in XML format
Hello there, I am trying to get column as the header and column value under the header. Header is the column name. Below is an example which provides me list of all the text under ...Answered | 12 Replies | 735 Views | Created by Palash Aich - Wednesday, July 31, 2019 4:45 PM | Last reply by Palash Aich - Friday, August 2, 2019 2:50 PM -
0 Votes
How to deal with large amount of XML in Sqlserver Database.
In a table we have 10 columns and out of that 2 columns has huge amount data. One column(XML datatype) stores XML data another column(NVARCHAR(MAX)) stores JSON data. Each rows size around 1.4 MB. ...Unanswered | 4 Replies | 540 Views | Created by Manas Mohapatra - Thursday, August 1, 2019 10:27 AM | Last reply by Erland Sommarskog - Thursday, August 1, 2019 9:21 PM -
1 Votes
SQL Server SSIS Export as XML Error: Name cannot begin with the '.' character, hexadecimal value 0x00. Line 1, position 40
I'm using SQL Server 2014 and SSIS. I have an OLE DB source using the below SQL command to output to a flat file destination - that is configured to save as ...Answered | 2 Replies | 531 Views | Created by ChairmanMichael - Tuesday, July 30, 2019 11:49 AM | Last reply by Viorel_ - Tuesday, July 30, 2019 5:35 PM -
0 Votes
Can I insert XML data into a table with "INSERT INTO" command directly?
Hi, Just wonder for a very very simple XML file, like below: <?xml version="1.0" encoding="utf-8" ...Answered | 6 Replies | 784 Views | Created by tempc - Sunday, June 30, 2019 3:27 AM | Last reply by Yitzhak Khabinsky - Monday, July 15, 2019 6:53 AM -
0 Votes
Problem to read XML files
Hi community I have a problem when i try to read my XML file from disk and i found that the problem is related with 3 TAGs with attributes. This is my XML File ...Answered | 5 Replies | 942 Views | Created by lafs - Friday, July 12, 2019 11:26 PM | Last reply by Yitzhak Khabinsky - Sunday, July 14, 2019 6:40 PM -
1 Votes
Can I insert UTF-8 XML into SQL Server?
Hi, Based on forum posts, it seems that only SQL Server 2019 starts to support UTF-8. Then for early versions of SQL Server, can I insert UTF-8 XML into SQL ...Answered | 7 Replies | 845 Views | Created by tempc - Wednesday, July 10, 2019 12:03 AM | Last reply by pituach - Thursday, July 11, 2019 9:11 AM -
0 Votes
Cannot bulk insert XML data into a table
Hi, I create a database called "XMLDB", then create a table called "XMLTable", then in the table, create a column called "XMLCol", which is ...Answered | 17 Replies | 899 Views | Created by tempc - Sunday, June 30, 2019 3:16 AM | Last reply by tempc - Monday, July 1, 2019 8:41 AM -
0 Votes
Open XML with Dynamic Schema
So this is my code snippet. all this doing is that it's calling an api to call a web service and get XML data. And then because I want to use this stored procedure dynamically for other XML files I ...Unanswered | 2 Replies | 830 Views | Created by nikan_af1 - Friday, June 14, 2019 2:44 PM | Last reply by Erland Sommarskog - Friday, June 14, 2019 9:13 PM -
0 Votes
I am unable to open any of my catholic Church bulletins on line I get this message, won't let me open:
<xsl:output method="text" version="1.0" encoding="UTF-8" omit-xml-declaration="yes"/> This is the message I get when ...Unanswered | 1 Replies | 676 Views | Created by Sadie 1918 - Thursday, June 13, 2019 2:57 PM | Last reply by Yitzhak Khabinsky - Thursday, June 13, 2019 5:46 PM -
0 Votes
Using an ID against dates for picking - problem when lastWeekEnd and lastMonthEnd are the same date!
= @lastMonthEnd ) t WHERE GRP IN (1,2,3) AND isin <> ''), LastValues AS ( SELECT ISIN ,LastBusinessDayCloseBidAskAVG = COAlESCE(MAX(CASE WHEN GRP = 1 ...Answered | 1 Replies | 671 Views | Created by TilleyTech Ltd - Monday, June 10, 2019 9:43 AM | Last reply by TilleyTech Ltd - Monday, June 10, 2019 2:15 PM -
3 Votes
Will OPENXML induces high THREADPOOL wait?
My developers love to write stored procedure with string parameter which essentially is XML value, and use OPENXML to extract data from it. Now our production database gets high THREADPOOL wait. Is it ...Answered | 11 Replies | 959 Views | Created by nonno - Monday, June 3, 2019 11:21 AM | Last reply by nonno - Tuesday, June 4, 2019 9:51 AM -
0 Votes
Command dialect is not supported by this provider
Hi, I am facing below error when using the following code snipet to write data in xml file: Code: ...Unanswered | 2 Replies | 907 Views | Created by adilrehman - Wednesday, May 22, 2019 7:43 AM | Last reply by Erland Sommarskog - Wednesday, May 22, 2019 9:33 PM -
0 Votes
Different Namespaces
Hello, I use a SQL trigger to generate a XML. My problem are the different Namespaces. How can I get ...Answered | 8 Replies | 1133 Views | Created by Ivandrago1988 - Tuesday, May 21, 2019 12:20 PM | Last reply by Yitzhak Khabinsky - Tuesday, May 21, 2019 3:42 PM -
0 Votes
Cannot Open Utf-16 File with .xml extension
hey i've a XMl file in a DVD and i can't copy it. So i opened it, copied the whole text written in UTF-16 encoding and pasted it in notepad on my system and saved in UTF-8 format. Now ...Answered | 3 Replies | 13065 Views | Created by Arcane Vits - Sunday, August 9, 2009 1:32 PM | Last reply by JS2010 - Thursday, May 16, 2019 4:56 PM - Items 1 to 20 of 3709 Next ›
No announcements
