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 | 50192 Views | Created by MRys - Friday, November 4, 2005 8:20 PM | Last reply by mafsar09 - Tuesday, February 12, 2013 3:53 PM
-
0 Votes
BCP XML to file
I am trying to export an XML file from an XML column in SQL Server 2012 and an getting a invalid XML file. When I copy the XML from the column and paste it into notepad and save it I can open it ...Unanswered | 9 Replies | 1479 Views | Created by RobertEGK - Friday, October 11, 2019 5:41 PM | Last reply by Erland Sommarskog - Friday, December 27, 2019 10:27 PM -
2 Votes
Trying to get SQL Server to read XML. Where am I going wrong
I've worked on SQL Server since 1.0. I even have the original box and manuals here. So I'm feeling pretty stupid right now that I can't get and XML fie to load. Here's the beginning of the XML ...Proposed | 5 Replies | 476 Views | Created by fldbryan - Thursday, December 12, 2019 5:11 PM | Last reply by clarc - Friday, December 27, 2019 3:05 PM -
0 Votes
Parse Soap XML Response and Insert into a table
I need to parse the below Soap XML Response values into a database table. Can someone point me in the right direction please? <soap:Envelope ...Answered | 4 Replies | 201 Views | Created by sql_guy_1982 - Sunday, December 22, 2019 11:54 PM | Last reply by sql_guy_1982 - Monday, December 23, 2019 2:35 AM -
2 Votes
extract data from a SharePoint Table (AllUserData) and the xml column tp_ColumnSet
Hello, I have a SharePoint SQL Table (dbo.ALLUserData) with an XML Column called: tp_ColumnSet. Within the column, tp_ColumnSet I have the following XML Data for Row ...Answered | 2 Replies | 3153 Views | Created by vsla - Thursday, September 29, 2016 9:36 PM | Last reply by Paulie D - Thursday, December 19, 2019 7:52 AM -
0 Votes
Using XQuery and Exists to check for attribute
Hi I am trying to query some XML to determine if an attribute exists within the element. I must be missing something as nothing I try works. My Query currently ...Answered | 9 Replies | 1080 Views | Created by fiddlerontheroof - Wednesday, November 6, 2019 5:26 AM | Last reply by Yitzhak Khabinsky - Sunday, November 10, 2019 12:27 AM -
0 Votes
Enter XML Data into SQL Server
here is the data: <?xml version="1.0"?> <BOMMAT04> <IDOC ...Answered | 5 Replies | 1189 Views | Created by Pallavi Acharaya - Wednesday, November 6, 2019 10:10 AM | Last reply by Dedmon Dai - Thursday, November 7, 2019 6:56 AM -
0 Votes
How to Query xml sub-elements using SQL
Hi, I have a field on each row of an SQL table that stores xml of my objects. I want to extract each element with a particular type to determine if it has a particular sub element. ...Answered | 8 Replies | 1260 Views | Created by fiddlerontheroof - Wednesday, October 23, 2019 4:55 AM | Last reply by fiddlerontheroof - Thursday, October 24, 2019 11:08 PM -
0 Votes
MSXML6.dll method"SEND" don't work in Windows Server 2012 and SQL 2008R2
Hi all, I have a SP to send a WebService data It works fine on Windows 2008R2 server and also on ...Answered | 17 Replies | 21096 Views | Created by Giancarlo.MADA - Sunday, February 24, 2013 10:10 AM | Last reply by SmurofNeves - Wednesday, October 23, 2019 1:26 PM -
0 Votes
Return only root tag of a document
For once it is time for me to ask a question. Say that I have an XML document like this: DECLARE @x xml = '<root attr1="1" attr2="snyltare" ...Answered | 3 Replies | 1375 Views | Created by Erland Sommarskog - Tuesday, October 15, 2019 7:41 PM | Last reply by Yitzhak Khabinsky - Wednesday, October 16, 2019 3:28 PM -
2 Votes
How to use new types like datetime2 in XML SCHEMA?
I'm trying to make tests for all primitive and simple types from select * from sys.xml_schema_types where kind = 'P' or kind = 'S' with queries ...Answered | 6 Replies | 1332 Views | Created by s73 - Friday, October 11, 2019 7:40 AM | Last reply by s73 - Friday, October 11, 2019 2:49 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 | 1491 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 | 1257 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 | 1241 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 | 1697 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 | 1243 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 | 2422 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 | 1785 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 | 1215 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 | 1269 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 | 1882 Views | Created by tempc - Sunday, June 30, 2019 3:27 AM | Last reply by Yitzhak Khabinsky - Monday, July 15, 2019 6:53 AM - Items 1 to 20 of 3717 Next ›
No announcements
