Sponsored Links

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

Page 6 of 68

Last »

Threads in Forum : microsoft.public.sqlserver.xml

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
XQuery and Datetime ( 1 2 ) Hello, how do I insert a datetime value in an xml variable ? «insert element Value {sql:variable("@Value")}» fails because DateTime is not supported... Fred	05-21-2008 07:01 AM Fred	11	253
Dimension limit of an XML document for SQLXML BulkLoad What is the size limit of an XML document to import by SQLXML BulkLoad 3.0 for SQL Server 2000? Thanks Pasquale	05-19-2008 06:08 AM Pasquale	0	57
How to get XML from an ADO recordset ( 1 2 3 ) I would like to pass the contents of a temporary table in Access to a SQL Server stored procedure string parameter via XML. Is it possible to get... Patrick Jackman	05-18-2008 05:22 PM Patrick Jackman	20	247
Use named ROOT for import XML document I want to import an XML document by SQLXML BulkLoad with the root element not named <ROOT> ... </ROOT>, but having a specified meaningful name. What... Pasquale	05-18-2008 12:49 PM Pasquale	0	60
Implicit setting of an identity field with SQL XML BulkLoad I'm using SQLXML 3.0. I want to import a XML document in a SQL table that has an identity field to value automatically. The XML document specifies... Pasquale	05-17-2008 05:48 PM Pasquale	0	54
SQLXMLBulkLoad with ODBC I have installed SQLXML 3.0 to use the SQLXMLBulkLoad functionality inside a VBScript code. Now, is it possible to specify in the connection string... Pasquale	05-17-2008 05:16 PM Pasquale	0	65
ancestor syntax ( 1 2 ) Hi, does MSSQL Server support the XQuery Syntax ancestor? 2ndsky	05-17-2008 02:49 AM Joe Fawcett	10	219
About installing SQLXML 3.0 for SQL Server 2000 I have downloaded SQLXML 3.0 to use the XML Bulk Load functionality. I have a client application that connect to a SQL Server 2000 on a... Pasquale	05-16-2008 07:46 AM Pasquale	0	58
Importing a txt file with XML content I'm using SQL Server 2000. I need to save the XML content contained into a txt file in a image SQL server field and then convert this field in a... Pasquale	05-14-2008 11:48 AM Pasquale	0	48
Identifying the nodes using OPENXML I'm using SQL Server 2000. I must import a document structured in XML. This document has a root, some invoice header nodes and inside a... Pasquale	05-14-2008 03:51 AM Pasquale	0	158
finding nodes in xml files ( 1 2 ) I have xml feed files that we investigate for bugs. The size of these files is quite big (ranging from 500 KB to 1.4 GB). My aim is to search these... Lothar	05-14-2008 02:45 AM Joe Fawcett	10	101
Help - XML bulk load to M:N with attributes Hi all. I am new to XML bulk load. I am trying to load an XML document into an M:N relation with additional attributes. The actual XML file and table... casey.d.chester@gmail.com	05-09-2008 09:15 AM casey.d.chester@gmail.com	0	144
Insert same Attribute value into multiple records using SQLXML I'm importing XML files into a SQLExpress DB using SQLXML and VB.net 2005. I have a simple *.xsd schema file that is pulling in all attributes from... JimP	05-08-2008 03:03 PM JimP	0	39
Stylus Studio 2008 Release 2: New EDI support & code generation Dear microsoft.public.sqlserver.xml, Stylus Studio 2008 Release 2 is now available.The following highlights some of the new features included in our... DataDirect Technologies	05-06-2008 12:31 PM DataDirect Technologies	0	36
Variable in Exist() ( 1 2 ) I'm trying to get this to work: ---- declare @s nvarchar(150) select @s = '(/Settings)' print @s select top 1 * FROM dbo.Paragraph WHERE... Morten Snedker	05-06-2008 11:50 AM Joe Fawcett	10	85
help with xml schema mapping To start off, I'm pretty new to XML. I have a huge XML data file and would like to import it into SQL 2000. I think I have a workable schema, but... rharmonster@gmail.com	05-05-2008 04:07 PM rharmonster@gmail.com	0	46
Performance problems with XQuery ( 1 2 3 4 5 ... Last Page) Hello All, I need some help improving the performance of queries that mix TSQL with XQuery. Some of our tables are defined like: create table A... CD	05-05-2008 03:23 AM ML	80	495
Importing XML to Database I'm trying to import a pretty simple XML file into a single SQL Server 2000 database table with SQLXML 3. Here's a snippit of the XML... BarCar	05-01-2008 02:10 PM BarCar	0	42
Create 2005 local cubes ( 1 2 3 ) I need to create a windows application in which I can programmatically create local cubes from SQL Server 2005 databases using C#. I was able to do... DCount17	04-29-2008 11:42 AM DCount17	20	132
Ahhhhhhhh XML bulk upload after several issues uploading a simple xml file to SQL i get numerous errors from SQL about the contained data being wrong. Question HOW ON EARTH... red	04-29-2008 11:19 AM red	0	65
sp_xml_preparedocument retrieve ( 1 2 3 ) Hi All expert, a quick question, i have one field type is text, now i need to retrieve that field value to get some data, text field contain xml... XJ	04-28-2008 11:09 PM Mike C#	20	214
request for book review ( 1 2 3 4 5 ) Can anyone provide a review of an XML book named Foundations Book II: Understanding SQL Server 2005 Supporting Technology (XML, XSLT, XQuery, XPath,... JOH	04-28-2008 06:52 AM JOH	40	386
How to view permissions of existing stored proc ? ( 1 2 ) Hello, I am trying to view the permissions granted to various users for a given stored proc. I tried "sp_helptext <stored_proc_name>". I also tried... Diwa	04-27-2008 11:45 PM Mike C#	10	85
Display SQL XML Column ( 1 2 ) How do I display an SQL XML data type (column) within classic ASP? Thank you in advance for your assistance. Terry	04-26-2008 11:11 AM Joe Fawcett	10	228
Insert carriage returns and line feeds in SQL 2000 XML output ( 1 2 3 ) I'm trying to insert carriage returns and line feeds to format SQL 2000 XML code. I'm running this code from Query Analyzer. What's happening is... lucycard	04-24-2008 07:26 AM lucycard	20	226
xquery -- inserting multiple elements ( 1 2 ) hey there for anyone familiar with xquery. is it possible to insert multiple element nodes using the below syntax? A singular item node works using... Kenny	04-23-2008 06:14 AM Martin Honnen	10	192
Updating XML documents stored within SQL Server ( 1 2 ) I have xml documents stored inside sql server. I know how to get back a piece of data using xquery eg: select... Crookie74	04-17-2008 03:00 PM Joe Fawcett	10	164
Unable to custom format XML with For XML Explicit Hi, Is it possible to format any kind of XML file with the FOR XML EXPLICIT mode in SQL Server 2005? I am asking because I am trying to format my... schtroumfps@hotmail.com	04-16-2008 08:53 AM schtroumfps@hotmail.com	0	55
XSD Schema Generates Error from SQLXMLBulkLoad 4.0 ( 1 2 3 ) I'm trying to Bulk Load an XML file with a Schema file that maps elements to database tables/columns. I get the error: "The INSERT statement... Kevin	04-16-2008 06:17 AM joao.jeko@gmail.com	20	194
Update DB Date Field when importing xml with SQLXML I'm importing xml files into a relational database using SQLXML through C# into SQLExpress I have the data going in ok but the tables have Date... JimP	04-09-2008 10:36 AM JimP	0	66
xml column/xpath w/ sql server ( 1 2 3 4 5 ) For the following xml, I want to the below query to update the second Item element, based off of a that "closedMessage" Key. Any suggestions? is... Kenny	04-07-2008 12:46 AM Kenny	40	356
Is there support for or planned support for xquery in the Tuning A Is there support for or planned support for xquery in the Tuning Advisor tool? Bob C.	04-04-2008 09:14 AM Bob C.	0	48
xquery question: Sample from MSDN2 not working, need advice. ( 1 2 ) From this page http://msdn2.microsoft.com/en-us/library/ms345117.aspx# The example for "Rich Language Constructs in XQuery" returns the... Bob C.	04-03-2008 09:09 AM Bob C.	10	208
Error Msg 6833 when running a SQL XML format query with the Executecommand Hi, I am working on a SQL Server query that is generating a XML file format (with For XML EXPLICIT) and I am getting an error in the SQL Server error... schtroumfps@hotmail.com	04-02-2008 03:06 PM schtroumfps@hotmail.com	0	136
Re: Merging xml Tag I've written three variations, none of which have been tested for performance. I suspect the first will perform the best. The first does not get rid... Peter DeBetta	03-27-2008 09:09 PM Peter DeBetta	9	52
XML to Database ( 1 2 ) I am now using SQLXML to load XML file into a SQLServer database. Here is how it works - XML(Data) + XSD(Schema) --> through MS SQLXML COM program... worlman385@yahoo.com	03-23-2008 12:23 PM Mike C#	10	119
Bulkload loading SOAP response XML Can Bulkload schema support mapping SOAP response XML into Database like follows? ========================== <?xml version='1.0'... worlman385@yahoo.com	03-23-2008 01:15 AM worlman385@yahoo.com	0	43
Sql Server 2000 errors when using MSXML2.DOMDocument to generate a xml file Hi all, I'm having troubles when using MSXML2.DOMDocument on SQL Server 2000 stored procedure to generate a XML file. The problem rises when... SammyBar	03-18-2008 10:19 AM SammyBar	0	120
[Updategrams] Combining DELETE and INSERT Hello, I have to develop a solution where a CSV-file has to be imported into a SQL Server database. The CSV-file contains multiple rows of data... Markus Eßmayr	03-17-2008 06:07 AM Markus Eßmayr	0	141
A question about using exist() method against XML column ( 1 2 ) Hi all, I have a question: When I execute this query: select * from Users where MyXmlColumn.exist('/user ') = 1 the result set contains only one... shawn	03-15-2008 06:34 AM Martin Honnen	10	67
XML Output Adding Line Breaks Hello, I am running SQL Server 2000 and am attempting to query data and save the results to an XML document. The problem is that for some reason, it... Chris Guimbellot	03-11-2008 06:11 AM Chris Guimbellot	0	67
XML file to SQL Server table - best way? ( 1 2 3 ) Background: We have some systems that perform tests on piece-parts and modules to see if they work and meet spec. The testers (boxes not people)... Doug_F	03-10-2008 06:10 AM Doug_F	20	123
Silent performance killer with promoted column Half open question, half dire warning ;-p I got stung yesterday by a curious performance issue on 2005 (I haven't tried it on 2008) - basically,... Marc Gravell	03-06-2008 03:02 AM Marc Gravell	0	47
SQL 2005 For Xml Path question ( 1 2 ) In the SQL 2005 Books Online section titled "Using PATH Mode", there is an example near the bottom that results in the following XML. Is there a way... Dave	03-04-2008 02:07 PM Dave	10	90
insert xml file into remote SQL Server 2005? ( 1 2 ) I'm stumped as to how to insert data (shredded) from an XML file into a table's columns. I tried using bcp but get "not trusted connection" error... Dabbler	03-02-2008 10:09 PM Mike C#	10	87
XQUERY big problem ( 1 2 3 4 ) Hello I try import data from XML file to MSSQL2005 using XQUERY xml like: <start> <section> <data1> </data1> <data2> </data2> <data3>... aja74	02-29-2008 07:47 PM Mike C#	30	186
Query an xml column ( 1 2 3 4 5 ... Last Page) I am having trouble querying a column in my sql server database that contains the following xml <BaseData... ProgramQuestions@gmail.com	02-29-2008 01:23 PM PG	80	319
Extract and Insert Xml nodes ( 1 2 3 4 5 ... Last Page) In SQL Server, how would you extract: <member member_id="3" /> <member member_id="4" /> from a sql column of type xml with value: <group... ndillon45@gmail.com	02-29-2008 12:16 PM Mike C#	70	253
how to insert xml into sql 2005 ( 1 2 3 4 5 ... Last Page) Using the following code how do I actually insert the data from the xml file into the sql 2005... Dee	02-28-2008 03:47 PM Michael Rys [MSFT]	260	751
Nested xml ( 1 2 3 4 5 ... Last Page) I'm having trouble getting the nested result (or tree structure) I'm wanting. I have data which is similar in structure to a table with columns... tewall@lycos.com	02-28-2008 01:29 PM Michael Rys [MSFT]	140	518

Page 6 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