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
-1
votes
2 answers

Use SQLXML with VB.NET

I'm new in .NET programming and Visual Basic and I have no much idea about it. I have the next code: Public Class Form1 Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click Dim cnn As New…
polgrana
  • 11
  • 5
-2
votes
1 answer

wildcard search update in SQL server for XML data coulmn

I have Table T1 which has one XML datatype column C1, here I want to update only domain name. do need to where for where condition, I have to update this for entire table Ex:- Data in Column C1 before update …
R.Agrawal
  • 1
  • 1
-2
votes
2 answers

SQL Server For XML Query

My table structure is as follows: date Id Value -------------------------------- 01/01/2005 50000 5 01/01/2006 50000 6 01/01/2007 50000 7 01/01/2005 50001 …
amrit
  • 315
  • 1
  • 2
  • 11
-2
votes
1 answer

SQL server query xml attribute closing on each field

I need to write a Sql server query to generate exactly this xml file. 0980 Working Arts Student My…
Muhammad Arif
  • 1
  • 1
-3
votes
3 answers

Select multiple tag values of xml in sql

I have an XML file where I need select value of name and value tag. device_index 1 1 1 trx_index 1 …
Arjun Sahoo
  • 3
  • 3
-4
votes
2 answers

Could not able to insert the xml data into a table

When i try to insert the values into the table am getting the below error. We cant remove the space in the XML because it is generated from Javascript. How to insert the below data into the XMLdata table. Conversion failed when converting date…
Daniel Stephen
  • 539
  • 1
  • 5
  • 10
1 2 3
…
31
32