Stack Overflow
Stack Overflow

Questions tagged [sqlxml]

SQLXML is a feature in MS SQL (introduced in SQL Server 2000), that enables XML support for making queries and processing data.

SQLXML was introduced in MS SQL Server 2000, and adds support for MSXML library into SQL Server. It allows the user to execute SQL SELECT statements that return XML instead of tabular data. In later versions(from SQL Server 2005), the XML support was extended with adding xml as a type in MS SQL Server to support XPath and XQuery over tables.

More info can be found in SQLXML's page in MSDN: http://msdn.microsoft.com/en-us/library/aa286527.aspx

471 questions
2
votes
1 answer

SQLXML on Azure Web sites

My application is using the library SqlXML and I am trying to publish this application to Azure Web Services. Once I publish it I get this error: Retrieving the COM class factory for component with CLSID {83D0FC3E-8B31-4B35-A1B2-346BA3954514} failed…
Daniel
  • 61
  • 1
  • 5
2
votes
1 answer

SQL get comma separated values of a column from XML

I am calling Scalar UDF from a stored procedure to get a column value. Inside the scalar UDF I have an xml and I have to get the comma separated values of a particular node. I am using Cross Apply but this is causing huge performance headache…
Ravish Kumar
  • 67
  • 1
  • 6
2
votes
3 answers

SQL Server 2000: Trouble with writing xml output

I need to set a variable @XMLOutput to the value of the subquery in XMLformat. The subquery works fine on its own, but when the whole query is run i get the error: Incorrect syntax near XML. SELECT @XMLOutput = (SELECT loc …
will
  • 35
  • 1
  • 4
2
votes
1 answer

Get specific XML Child node in SQL Server

I am trying to load XMl to different tables with logical keys in MS SQL Server. I am stuck as I am getting all child nodes in SQL. Book1 abc Amazon …
Pratik Patel
  • 78
  • 1
  • 9
2
votes
2 answers

Insert data from XML file into existing SQL Server table

I need to insert data from XML file into existing SQL SERVER table. I have modified following code to INSERT INTO but its not working. I don't want to delete or create new table in this statement DECLARE @x xml SELECT @x=P FROM OPENROWSET (BULK…
K.Z
  • 5,201
  • 25
  • 104
  • 240
2
votes
1 answer

Querying (a lot of) XML data for specific text with in xml Elements (Tsql)

Sorry: this post got a little long (wanted to make sure everything relevant was in) Struggling to wrap my brain around this a little. I have a table that has 5 columns ID (varchar) Record value(XML) date (datetime) applicationtypeid…
Nighthawkz
  • 59
  • 8
2
votes
3 answers

Dynamic Insertion Location of XML Node in Existing Instance Using XML-DML

I haven't been able to find any documentation if it's possible to insert an xml node dynamically within an existing xml instance in SQL Server (2012). I know that you can have a conditional value inserted or replaced, but there doesn't seem to be…
JNYRanger
  • 6,829
  • 12
  • 53
  • 81
2
votes
1 answer

xsd schema file must be annotated in SQLXMLBULKLOADLib.SQLXMLBulkLoad4Class?

Here is an example to use SQLXMLBULKLOADLib.SQLXMLBulkLoad4Class - [STAThread] static void Main(string[] args) { try { SQLXMLBULKLOADLib.SQLXMLBulkLoad4Class objBL = new…
Don
  • 1,532
  • 4
  • 24
  • 47
2
votes
2 answers

Invalid character value for cast specification

I am inserting data into SQL 2005 using SQLXMLBulkLoad.SQLXMLBulkload.3.0 My data table has following column: objDataTable.Columns.Add("TaskDateTime", System.Type.GetType("System.DateTime")) My bulk insert schema has following…
Usman Akram
  • 271
  • 6
  • 16
2
votes
1 answer

T-Sql MERGE statement update when criteria matches newly inserted record

This is the XML I have: 1 1 2 23 11052 …
HABJAN
  • 9,212
  • 3
  • 35
  • 59
2
votes
1 answer

Creating Nested XML File in SQL Server

I have 3 tables and I need to join the 3 tables in order to create a nested XML file The tables are Events, UserEvents and Users. Here is an example schema: create table [dbo].[Users] ( UserID int, Username VARCHAR(MAX) ); insert into…
Powellellogram
  • 426
  • 1
  • 6
  • 17
2
votes
1 answer

Avoid encoding of ampersand in SQL XML attribute

Image I have a currency table, containing e.g. this record : - Id = 1 - Code = EUR - Symbol = € Important to notice : The input in our database is already property HTML-encoded! Now, when I use this SQL statement : SELECT '@id' =…
Christof Colle
  • 23
  • 6
2
votes
2 answers

parsing xml using sql server

Needed some help to parse text in Paragraph element in following XML in SQL server. Licence…
Sidharth Soneja
  • 31
  • 1
2
votes
1 answer

How to select each value for xml node sql server

I have an xml column within my sql server table where the XML looks like this:
51
…
Derek Buchanan
  • 23
  • 5
2
votes
2 answers

Why are carriage returns removed when modyfing XML attributes in SQL Server?

In SQL Server 2014, I try to add an XML element with an attribute (that contains a carriage return) using the 'modify' method on the XML datatype. The carriage returns gets removed - why is that? Example: declare @xmldata xml select @xmldata =…
Thomas Boel Sigurdsson
  • 73
  • 7
1 2 3
…
31 32