|
|
| XML in SQLServer 2005/2008 |
| I am beginning to learn XML with SQLServer. If SQLXML delivered the features
in SQLServer 2000 and if it is deprecated in SQLServer 2005/2008 what
component
delivers the XML features in SQLServer 200... on 20-Nov-09 |
| |
|
|
|
| parse xml |
| I need to parse the above xml such that it returns the attributes in a flat
format,
e.g. abc,123
How can this be achieved using sql 2005 on 14-Nov-09 |
| |
|
| I fail to put a XML into a table |
| Hi all.
I just cannot get to the item values and hope anyone can help me. Here is the
XML i have got into at one row tabel an XML datatype column.
CREATE TABLE #LevInfoXML (pk int primary key identi... on 04-Nov-09 |
| |
|
| 49 Hosting Web www.ivys.es |
| Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting... on 04-Nov-09 |
| |
|
| XML shred of XML data in table returing null values |
| Using SQL 2008, I have a table (tmpXML) with 2 columns
CREATE TABLE [dbo].[tmpXML](
[pk] [int] IDENTITY(1,1) NOT NULL,
[Field1] [xml] NULL,
CONSTRAINT [PK_tmpXML] PRIMARY KEY CLUSTERED
(
[pk] ASC
)W... on 29-Oct-09 |
| |
|
| Querying XML element values |
| Using SQL Server 2005
--First the Schema Collection and table definition
CREATE XML SCHEMA COLLECTION [dbo].[VALIDXML] AS
'
'
/****** Object: Table [dbo].[XmlLog] ... on 27-Oct-09 |
| |
|
|
|