Sponsored Links

microsoft.public.sqlserver.xml microsoft.public.sqlserver.xml

Page 5 of 68

Last »

Threads in Forum : microsoft.public.sqlserver.xml

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
XQuery: Update multiple XML nodes ( 1 2 3 ) Hello, I'm trying to update multiple nodes in an XML column in one update statement but am getting the error: Column name 'xmlEmail' appears more... Leon Mayne	09-02-2008 08:20 AM Leon Mayne	22	215
Response time ( 1 2 ) I have a table with 37000 records with a int column and a xml column. The int column have primary index, the xml column have primary index, path... byteman	09-02-2008 05:26 AM Jacob Sebastian	11	83
OPENXML from column value ( 1 2 ) Hi, I'm storing some data into column X converting it to XML like: UPDATE xxx SET column_xml = (SELECT sth, sth2 FROM yyy WHERE {condition}). Now I... micmixx@gmail.com	09-01-2008 04:46 AM Bob	11	190
Modify multiple attributes ( 1 2 3 ) If I have the following xsd, how can I update it: all attributes named type with value of "xs:integer" to "xs:decimal" all attributes named type... Bob	08-30-2008 10:37 AM Bob	22	146
Return all Elements from XML Segment (SQL 2005) ( 1 2 ) Hi, I need to be able to return all Elements from an XML segment that is stored in a SQL 2005 XML column. The column does not have an... kkam99504	08-30-2008 06:29 AM Bob	11	165
another xml => sql tables question Still don't understand why simple things don't stay simple .... I have tons of xml data files.....and xsd's that are not good enough to create... Travis McGee	08-21-2008 04:47 PM Travis McGee	0	55
is it possible to use parameter as the XQuery string in xmlColumn.query()method? ( 1 2 ) Hi guys: select experience.query(N'/root/experience') from UsersProperties the code above works, but I want to use parameter to substitue... shawn	08-21-2008 10:33 AM Martin Honnen	11	185
Shaping this query ( 1 2 3 4 5 ... Last Page) Hi, I'm having a go at an xml query but I'm having problems getting the correct results with the output xml. Say I have the following... spondishy@googlemail.com	08-21-2008 09:29 AM Jacob Sebastian	77	535
SQL/XML Annotation Question - a different take ( 1 2 3 4 5 ... Last Page) So..... we have these files from different vendors in XML to be loaded into SQL Server. Looks like they don't have the annotation/relationship... Travis McGee	08-20-2008 01:33 AM Jacob Sebastian	55	626
Annotation question Hi, I was wondering if anybody could assist me with annotated XSDs when attempting to bulkload XML. Here's the structure of the xml I'm receiving and... Scienter	08-19-2008 02:37 PM Scienter	0	51
querying for text in an XML field ( 1 2 3 4 5 ) Using SQL 2005 I've not much experience with XML and SQL 2005. I have a field of XML datatype. How do I look for a specific string within the XML... Steven	08-19-2008 02:15 AM Jacob Sebastian	44	167
annotation issue with SQLXML ( 1 2 ) I am getting "relationship expected on" errors on SQLXML Loading Code when I am creating the tables and then perhaps adding.inserting the... Travis McGee	08-18-2008 09:36 PM Jacob Sebastian	11	77
generating sql explicit xml from schema ( 1 2 3 4 ) Is there anyway to generate sql that uses explicit xml from a schema or xml sample? an example of sql using explicit xml: except what I have to is... Stever1975	08-17-2008 10:52 PM Jacob Sebastian	33	244
Help with SELECT FROM OpenXML ( 1 2 3 4 5 ) In the FROM below what is the correct syntax for the following? IsNew="-1" AND IsDeleted="0" Declare @DetailsXML XML SET @DetailsXML =... Patrick Jackman	08-17-2008 10:18 PM Jacob Sebastian	44	158
RE: Please help: OPENXML and nodes() processing difference of leading ( 1 2 3 4 5 ) I found that by encoding the first space it picks up the others. SET @xml = '<root> <ProductLines> <ProductLine ProductLineCode="OF"> <Feature... Bob	08-17-2008 09:35 PM Jacob Sebastian	43	151
fieldname and field value in a table ( 1 2 3 ) Hi For generating audit reports, I want to populate a sql table with fieldnames and fieldvalues (converted to varchars) from a table. Example if... pi	08-17-2008 04:24 PM pi	22	213
IT Job Guru Are you looking for a Job in India??? You have experience in Java, Oracle, .NET, SQL Server, SAP and testing tools. Than you can wait a minute and... Naveen	08-12-2008 02:21 PM Naveen	0	69
2000 = SQLXML 2005 = ??? (what is SQLXML replaced with in 2005) ( 1 2 ) Does anyone know what to use now instead of SQLXML to simply output XML over HTTP? I don't need any WSDL at this stage although it would be nice,... clickfind™	08-11-2008 03:55 PM Mike C#	11	70
SELECT .... FOR XML and data alignment in the table ( 1 2 3 4 ) This is taken from SQL 2005 help from sp_send_dbmail article: DECLARE @tableHTML NVARCHAR(MAX) ; SET @tableHTML = N'<H1>Work Order Report</H1>'... John_Doe@inbox.ru	08-09-2008 11:40 PM Michael Coles	33	156
Invalid XML elements found inside sync block ( 1 2 ) I'm getting the above error when updating a SQL server table using a updategram, with a mapped schema. There is no $ symbol in the XML, nor do I... Sam Judson	08-08-2008 08:49 AM Sam Judson	11	286
xsd/xml to sql ( 1 2 3 4 ) Hi All, I am looking for a way to import xml data into ms sql, using xsd to create the tables. I have tried bulkuploader but it keeps having issues,... con	07-23-2008 05:31 PM Bob	33	166
problem with attribute in xml file ( 1 2 3 4 5 ... Last Page) Hi I'm using xml bulkload using sql server 2000. The XML files are dependent on an xsd schema - The bulkload works fine when there is no reference... jojo123	07-18-2008 08:54 AM jojo123	77	365
Microsoft Project REAL issue with REAL Warehouse Sample V6 MT.xmla After execution of "REAL Warehouse Sample V6 MT.xmla," I get the following errors. I have followed the steps to set up Project REAL and yet only a... Rick	07-14-2008 09:44 AM Rick	0	128
XML indexes fragmentation 99% Hi After the creation of my database and the inserting of data in this database, the xml indexes are fragmented (99%). My application publishes... Fabrice Guillet	07-11-2008 08:22 AM Fabrice Guillet	0	43
URGENT - Using XML Source - Related issues and usage Using XML Source - Related issues and usage Posted 10th July 2008 URGENT Help Required Tools using:- SQL Server 2005 SSIS (devenv.exe) rmsterling	07-10-2008 05:53 AM rmsterling	0	160
How to keep html encoding? ( 1 2 ) I have a table which stores xml content on a sql 2005 server. The content column is data type xml. How can I get html encoded entities back from... peter.aluotto@gmail.com	07-10-2008 03:23 AM Joe Fawcett	11	121
newbie to xpath/xquery trying to pull email address out of xml inSSRS subscription table ( 1 2 3 4 5 ... Last Page) i'm trying to pull out email addresses info from the SSRS subscription table. The xml looks like... kent.eilers@res-direct.com	07-09-2008 09:16 PM Michael Coles	77	263
Trigger won't fire using SQLXML 3.0 ( 1 2 3 4 ) I'm using SQLXML 3.0 with VB.net to upload xml files to SQL Express. One XML uploads to multiple SQL tables. One table has a trigger to update fields... JimP	07-09-2008 04:30 AM Bob	33	264
Problems with xml bulkload ( 1 2 3 4 5 ... Last Page) Hi I have the vbscript below in my dts package and xml schema, where I specify which sql table field the data would go into - whilst I don't get any... jojo123	07-08-2008 06:51 AM jojo123	77	257
Permissions problem configuring virtual directory SQLXML ( 1 2 ) Hi I'm using SQL2000 on a Win2K server. I am having some difficulty configuring the security on the virtual directory for SQLXML I am using the... Feargal	07-04-2008 08:25 AM Feargal	11	79
How to use a Variable in XQuery? ( 1 2 ) Hello, I have a XML as below: declare @doc2 xml SET @doc2 = '<?xml version="1.0" ?> <p1: Domains_and_Emails... Ganesh Muthuvelu	07-02-2008 06:04 PM Bob	11	87
xml dml conditional attribute inserting does not work ( 1 2 3 ) Hi, I'm experimenting with XML DML. I need to add an attribute only if it meet some condition. But I can not use an sql variable to implement... SammyBar	07-01-2008 06:09 PM SammyBar	22	121
xs:dateTime does not accepts ISO 8601 local time ( 1 2 ) Hi, I'm validating a Xml against a schema but I get error validating ISO 8601 datetime value. The fragment of the schema is <xs:attribute... SammyBar	06-30-2008 07:26 PM Michael Coles	11	261
bypass CDATA transformation ( 1 2 3 4 ) Hi, You know that when you INSERT or UPDATE in a XML type field of table, SQL Server deletes the CDATA et encode the section with HTML... Lobrys	06-30-2008 07:52 AM Lobrys	33	220
Compare 2 XML Columns ( 1 2 3 4 5 ... Last Page) Hi all: I have a table with 2 XML type columns of the same structure. How do I compare these 2 columns and return the difference? For example, here... Tom	06-29-2008 05:45 PM Bob	61	449
Change XML Attribute value with SQL XML DML/XQuery? ( 1 2 ) Is it possible to change an attribute value using XQuery? I understand how to use "modify" to change an Element value, but can you change an... Felix	06-27-2008 10:36 PM Michael Coles	11	102
Create XML, first line ( 1 2 3 4 5 ... Last Page) How do I add <?xml version="1.0" encoding="UTF-8"?> to the first line of the output from this query? select 1 as TAG, NULL as Parent, xx as , yy as ... Anders	06-27-2008 04:56 AM Bob	77	656
SQL to XML question ( 1 2 3 4 5 ) Hi SQL/XML experts. I'm building a query that creates a XML output. select name,place,salary from consert,artist where consert.artid... titten@tei.no	06-27-2008 04:22 AM Bob	44	419
loading xml data into sql server relational db using example from http://support.microsoft.com/kb/316005 with a small change... How do I modify customermapping.xml to populate the Sourcefile field... Bill	06-18-2008 04:00 PM Bill	0	41
FOR XML PATH node element containing "<" character ( 1 2 3 ) I want my result set to include the "<" character within the node element name however the sql compiler is returning an invalid character err. msg.... jose.mendez22@gmail.com	06-16-2008 08:44 PM Michael Coles	22	110
sql:relation and sql:field hi a have a "code" element in my schema this element maps to the "client" table (wich PK is "client_id" ) i need to get, for a specific node the... keyser soze	06-13-2008 11:39 AM keyser soze	0	68
Extract element name and attribute name-values from XML ( 1 2 3 4 ) In SQL Server 2005, if I have an XML variable that I know contains a single element, but I don't know what the element's name is, or the names of its... mj2736@yahoo.com	06-05-2008 12:56 PM mj2736@yahoo.com	33	231
SQLXML Import with nested elements ( 1 2 ) I am new to SQLXML and have found the tutorial for importing using an XDR schema. The problem I am having is that my xml file has nested elements,... eczino@gmail.com	06-04-2008 12:19 PM eczino@gmail.com	11	82
Saving Mal-formed XML ( 1 2 ) I am converting thousands of XML files to a SQL Server 2005 Database. Everything goes fine, until I run into a section of mal-formed XML. In passing... Terry Carnes	06-04-2008 02:12 AM Joe Fawcett	11	168
Implementing IODEF XML Schema in SQL 2005 ( 1 2 3 4 5 ) Hi folks, I'm new to XML and need to implement the IODEF XML Schema (http:// staff.science.uva.nl/~demch/projects/iodef/index.html) in SQL 2005. I... Matt	06-04-2008 12:10 AM Michael Coles	44	139
Using WITH XMLNAMESPACES in a function ( 1 2 3 4 ) Dear SQL Server XML experts, I have a problem with using the WITH XMLNAMESPACES clause within a function. This function shall return an XML fragment... FaensenD@rki.de	06-02-2008 05:29 AM Rudolf Dvoracek	33	398
Querying/Updating XML in SQL 2005 ( 1 2 3 4 ) Sorry if this posted twice, I think I hit the post message too early. Here is my complete post: I have the following XML store in an XML column in a... knowthediff@gmail.com	05-29-2008 11:06 PM Michael Coles	33	375
remote SP to shred local XML file ( 1 2 3 4 5 ... Last Page) SQL Server 2005 I have an XML file and I'm using a stored procedure to shred it into tables. Works perfectly so long as the file is on the... JOH	05-28-2008 09:22 AM JOH	55	373
How to retreive parent nodes and values from a child node? Hello, I have an XML as below. declare @doc2 xml SET @doc2 = '<?xml version="1.0" ?> <p1:Domains_and_Emails... Ganesh Muthuvelu	05-23-2008 12:49 PM Ganesh Muthuvelu	0	55
Retreiving Namespace URI ( 1 2 3 4 ) Hello, I have a XML as below: declare @doc2 xml SET @doc2 = '<?xml version="1.0" ?> <p1: Domains_and_Emails... Ganesh Muthuvelu	05-21-2008 02:18 PM Mark	33	334

Page 5 of 68

Last »

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off