No announcements
Filter
:
All Threads
All Threads
Answered
Unanswered
Proposed Answers
General Discussion
No Replies
Helpful
Has Code
All Languages
-
Sticky0VotesWelcome 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 ...
-
Unanswered0VotesGenerate xml using FOR XML PATH from table with hierarchy
I need to create xml from a table like: EL1 EL2 EL3 Attr01 Attr02 Attr03 Attr04 E10, , ,a,b,c,d E10,E1010, ... -
Unanswered0VotesGenerating XML from multiple rows in SQL server
I have the following table below and i would like to generate an XML from it. How do i go about doing this please. All help appreciated. Thanks ... -
Unanswered0VotesFOR XML AUTO, ELEMENTS XSINIL, BINARY BASE64 removing some whitespace from nvarchar(max) column
Hi, Currently I create a FOR XML based select query for tables on the fly in a shared stored procedure. On tables with columns of type nvarchar, in this case ... -
Unanswered0VotesUnable to read from the Extended Event parser
This is not working...in SQL Server 2012 also.. Getting the below error, while reading from the Extended Events (.xel ... -
Unanswered1VotesSql server StandardBusinessDocument xml in ApplicationResponse node query
declare @x xml set @x='<sh:StandardBusinessDocument xsi:schemaLocation="http://www.unece.org/cefact/namespaces/StandardBusinessDocumentHeader PackageProxy.xsd" ... -
Answered1VotesOPENXML question
Hi, I have the following xml file: <Root> ... -
Answered0VotesUpdate xml attribute from sql server 2008 r2 table based on attribute value
The following is the xml column in a table I am working with drop table T go CREATE TABLE T (i int, x xml) go INSERT INTO T ... -
Answered0VotesHow to find all values from a tag of an XML feed in a sql table
Create table #test (Key int, Feed XML) Insert into #test ... -
Proposed4VotesUnable to persist language specific characters into the database column of xml datatype
I need to save language specific characters in a column of xml datatype, because XML is the format that I want it to be when I retrieve it. Just before persisting, I see the ... -
Discussion1VotesHow to list varying list of drivers from XML Feed as columns in SQL table
I have an SQL table Create table #test t (Code int , Feed XML) Insert into #test('1','<R xmlns:xsi="http://www.w3.org" ... -
Answered0VotesFinding all tags of XML column from a SQL Table
Hello, I have an SQL table Create table #test (Key int, Feed XML) Insert into #test('1','<Input> ... -
Proposed0VotesSQL to RSS Products. Which ones are available?
Does anyone know of some SQL to RSS Feed applications that you can recommend? We are currently using xSQL RSS ... -
Answered0VotesSQLXML Error on converting some varchar values to int with FOR XML PATH
Hi All I have a select statement in a stored procedure using FOR XML PATH It contains amongst others a select on a VARCHAR col called 'Remark' which is output as ... -
Answered0VotesSQL XML Format datetime conversion
I have datetime column in my table with value: 2011-12-10 00:00:00:000 I tried converting that column to create XML file as ... -
Answered0VotesCreate xml file in the following format
-- DROP TABLE #Temp CREATE TABLE #Temp (LastName VARCHAR(100), ... -
Answered1VotesHelp Need parsing XML Multiple Attributes...
Hi I have a below XML Document which I want to Parse an XML document... I need to see the Thanks Desired ... -
Unanswered1VotesElement without child-elements (null) appearing and not solved with xsinil
I have an element of the xml with an attribute and inside that element, some sub elements. When those sub elements do not exist, the tag appears as well. When I use the xsinil ... -
Answered1VotesXml Query Performance Remove Wildcard
Hello, I have the below data structure The query is taking a while to run. I have a primary xml index, secondary xml indexes, and selective xml index on the table, (which ... -
Proposed0VotesFOR XML EXPLICIT ERROR
I want to assign the result of a SELECT FOR XML EXPLICIT statement to a XML Variable such as CREATE PROCEDURE BILLING_RESPONSE AS DECLARE @Data AS XML ... -
Answered1VotesRead XML Tags Using SQL Query
<University> <RegistrationCode>12859</RegistrationCode> <Colleges> ... - Items 1 to 20 of 3029 Next ›


