Sponsored Links

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

Page 3 of 68

Last »

Threads in Forum : microsoft.public.sqlserver.xml

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
SQL Server 2005 Express SP3 Install I have MS XML6 SP2 installed on a XP SP3 Home edition PC. When trying to install the SP3 upgrade to SQL it fails with a messeage in the log that the... KevinF	04-02-2009 10:31 AM KevinF	0	164
XML parsing using SQL-Server Hi, lets say I have the following xml file: declare @x xml set @x =... Majid	04-02-2009 06:12 AM Martin Honnen	1	165
I can't get exist to work in Sql query I am a rank beginner, so I hope my question isn't too stupid. I am working on Sql 2005. As a exercise, I am supposed to aggregate the sales from... Bev Kaufman	04-01-2009 10:47 PM Bob Beauchemin	2	119
ANN: XMLMax Beta Adds Indexing For Faster Xpath Query March 30, 2009 Xponent is pleased to announce Beta version 2.0.6 of its XMLMax Virtual XML Editor. This version introduces two features,... drewarmentino@xponentsoftware.com	04-01-2009 05:08 PM drewarmentino@xponentsoftware.com	0	130
SQLXML3: where is sqlvdir.dll and is it my only option? Hi, we are using the legacy SQLXML3 component to produce xml via templates from an sql server 2005 installation. Works great. But: we need to... DC	04-01-2009 03:08 AM DC	1	131
XML BULK LOAD I'm trying to load an xml document into a sql server table using vbscript and sqlxmlbulkload. The xml file has a header element with the filename,... Bill	03-31-2009 02:56 PM Bill	0	183
Can not use a sql variable inside the into part of a xml insert statement Hi all, My server is Sql Server 2005. I'm trying to insert data inside an xml variable. This code works: Set @xmlDirectorio.modify(' insert... SammyBar	03-28-2009 07:58 PM Bob Beauchemin	1	150
Can you reuse nested XML subqueries? I'd like to reuse the nested part of an XML query in multiple stored procedures. The nested part may be fairly complex, and I'd like to only maintain... Loren Halvorson	03-26-2009 07:56 AM Loren Halvorson	0	193
Need help w/ importing data via web services Hi, This is my first time creating a web service on SQL Server so I would appreciate some pointers. Please find the T-SQL syntax below. Here's what... Sam	03-24-2009 10:39 AM Bob Beauchemin	1	158
missing elements while passing XML from .NET to SQL 2005 Hi, I am calling an SP from my .NET class. SqlParameter prmMessage = new SqlParameter(); prmMessage.ParameterName =... Pradeep	03-20-2009 07:36 PM Michael Coles	2	190
Export well formed xml to a file Hi, I have a sql proc with for xml explicit were I in a dts package export the data to a file with MSXML. Now I need to do the same in SSIS and have... Micke	03-20-2009 03:18 PM Micke	1	147
Export well formed xml to a file Hi, I have a sql proc with for xml explicit were I in a dts package export the data to a file with MSXML. Now I need to do the same in SSIS and have... Micke	03-19-2009 02:41 PM Micke	0	129
Missing few elements while passing XML from .NET to SQL 2005 I am calling a SQL procedure(SP) from .NET class. Below code is written in .NET SqlParameter prmMessage = new... Pradeep	03-19-2009 05:50 AM Pradeep	0	114
Import XML with multiple sublevel nodes Hi all I need to set up an xml import procedure that allows large-scale xml records to be imported into multiple tables. I am currently using... Crud	03-18-2009 10:19 PM Michael Coles	1	237
XML parsing: ... illegal xml character WHY do I get this , "XML parsing: line 3, character 13, illegal xml character" when using UTF-8 ?? declare @myxml xml; set @myxml = '<?xml... Josh	03-18-2009 06:15 PM Michael Coles	3	173
XML schema Hi One of my data sources is about to be changed from .csv to .xml so I thought I had better familiarise myself with loading xml into SQL2000... NH	03-17-2009 10:03 AM NH	0	124
dealing with special characters using SP_XML_PREPAREDOCUMENT I am trying to use SP_XML_PREPAREDOCUMENT and it is having a problem with this line in the xml. <Param name='@i_sCarrierCodeAN' datatype='STRING'... Doogie	03-12-2009 12:31 PM Doogie	2	205
Changing MimeType Is there anyway of changing the MimeType returned/served by MSSQL/XML. I would really like to serve application/vnd.google-earth.kml+xml from... Feargal	03-06-2009 08:29 AM Feargal	0	184
XML EXPLICIT Help I guess I don't understand XML EXPLICIT or don't know how to go more than a level or two deep. What I want as output is below (along with my... Don Miller	03-04-2009 09:22 AM Bob	6	154
Retrieving XML Field data as Text I apologize if this is a dumb question. Having just returned from a funeral, I'm not thinking too clearly, yet still trying to get some work done. I... Terry Carnes	03-02-2009 09:43 PM Bob Beauchemin	1	130
Retrieving XML Field data as Text I apologize if this is a dumb question. Having just returned from a funeral, I'm not thinking too clearly, yet still trying to get some work done. I... Terry Carnes	02-27-2009 02:50 PM Terry Carnes	0	123
Storing multiple documents in nText field using XML We have a ntext field that was used to keep a single word document, now suddenly the requirement changed and we need to keep 3 versions of... pxb	02-12-2009 12:43 AM pxb	0	145
SQL Server performance issue We are facing performance issues while running SQL Server 2000 DTS package in 64 bit Server SQL Server 2000. In 32 bit server it takes 20 mts but in... Girish_Kunnath	02-10-2009 10:02 AM Girish_Kunnath	0	236
OPENXML to accept both attributes and elements Hi all, Is it possible to retreive values from XML document whether they where sent as elements or attributes, using OPENXML? For example, if someone... Goran Djuranovic	02-09-2009 03:06 PM Bob	3	146
Exporting SQL Server data to XML Hello Can anyone please suggest the best way to address the following problem (I did Google, but couldn't find anything): I have been given a SQL... Amir Tohidi	02-05-2009 10:13 AM Amir Tohidi	2	189
XQuery - Only return if not null Hi there I have the following (simplyfied) xml document, which is hold in one of my table columns: <Root> <ElementABC P1="07" P2="07"/> <ElementDEF... Mike Müller	02-03-2009 03:30 PM Mike Müller	2	162
How to Find Missing > in an XML Doc I have an xml doc that I load to SQL every month and on insert it is giving me an error. It says it is missing ">" on a tag. Is there an easy way... Chris	02-02-2009 01:32 PM Bob	1	176
Fast Import/Export of XML data into a Microsoft SQL Server database I want to be able to import and export large amounts of data from a SQL Server database using XML. That is, I want the data exported in XML format,... John Mann	02-02-2009 04:42 AM John Mann	0	313
OPENXML Question Here is my code and I just get nulls for an answer. Thoughts? DECLARE @doc xml David Olsen	01-30-2009 05:21 PM David Olsen	4	136
Help with Inserting/Reading individual XML nodes in a XML Field Unfortunately I'm a SQL Newbie. I would really like a C# example using SqlCommand that will allow a arbitrary XML node (containing a string) to be... Cadwell	01-26-2009 05:44 PM Cadwell	0	127
xml datatype and SELECT ... FROM @xml i have an XML datatype variable and can query from it like this: DECLARE @doc INT, @Stops XML EXEC sp_xml_preparedocument @doc OUTPUT,... Dan Holmes	01-21-2009 01:47 PM Dan Holmes	3	166
Parsing an XML string I have an XML doc stored in SQL Server 2000 as a varchar(max). It looks like below. <MyData... C	01-20-2009 08:36 AM Bob	4	133
Shred XML question I am a total newbie when it comes to XML. I have external xml file I am importing into a tsql variable. That works fine. I am trying to use... RJ	01-19-2009 09:17 AM RJ	2	158
tool like XMLSpy 2006 Home Hello, as a beginner in XML i would like to make some exercises from time to time. And because it's just for playing a little bit around with XML, i... Helmut Woess	01-16-2009 03:27 AM Joe Fawcett	2	280
FOR XML PATH question Hello all, I am trying to get a list of materials needed for and item in an xml format such as <item ...attributes...> <material... Sean	01-09-2009 08:17 AM Sean	2	186
Xml xquery join Hi, Im not sure if im doing this query correct. I am trying to pull back information when testing it but it is showing a empty table. Can anyone... Hung Hoang	01-03-2009 10:25 AM Bob	1	176
Export - best way to export XML in an XML field to a file or set offiles? I'm trying to figure out the best way to automatically export two fields to a file from a table. The first is a bigint column (the ID field for that... M Bourgon	01-03-2009 10:11 AM Helmut Woess	1	235
XML document referenced as an idoc? I have a stored procedure which passes a reference to an XML document (SQL 2000 style) using an int variable @idoc to another proc. The receiving... Dixie Normous	12-31-2008 04:01 PM Dixie Normous	0	94
XML document referenced as an idoc I have a stored procedure which passes a reference to an XML document (SQL 2000 style) using an int variable @idoc to another proc. The receiving... Dixie Normous	12-31-2008 03:57 PM Dixie Normous	0	80
SQL 2005, is there a way to determine whether a specific node existsin an XML variable? ( 1 2 ) For example, say I have the following XML: ..... ......... ......... ......... ............. 123 ............. 234 Dixie Normous	12-31-2008 11:25 AM Martin Honnen	12	258
Cross Joining two XML columns, or two (or more) XML variables ( 1 2 3 4 ) Hello, I am trying to filter an XML variable @RoleList with the approved roles in a similiarly structured XML variable called @ApprovedRoles . What... Schwartzenberg	12-18-2008 03:13 AM Schwartzenberg	31	421
Strange XML behaviour ( 1 2 ) Can anyone explain why I get an error in the last print statement? DECLARE @myXml XML set @myXml = '<root></root>' print cast(@myXml as... Frode	12-17-2008 01:22 PM Frode	12	270
FOR XML PATH and empty list ( 1 2 3 ) Hi I'm simply listing records from a database into such xml: <LIST> <ITEM id=1" /> <ITEM id=2" /> ... </LIST> I was using FOR XML EXPLICIT for that... Miroo	12-15-2008 08:19 AM Miroo	24	346
Returning rows and colums from semi-related data ( 1 2 3 4 5 ... Last Page) Hi - hope someone can help with this. Consider the following XML: declare @xml xml set @xml =... sean	12-14-2008 01:54 PM Bob	60	642
Re: XQuery Question - Conditional sum() ( 1 2 ) Bob, It works. Thank you very much for your help. Obviously, I was thinking too much and not good enough at XQUERY yet. notlkk	12-12-2008 11:38 AM notlkk	11	151
newbie - parse filepath field into xml doc ( 1 2 3 ) I have a SQL 2005 table that stores filenames with attached path. Could someone point me to a way to parse the path/filename into an XML... Mike Stokan	12-05-2008 07:18 AM Bob	24	140
Can FOR XML PATH create truly _empty_ elements? ( 1 2 3 ) I'm having difficulty doing something that should be really simple. I need to be able to generate empty elements (eg. <tag/>) using FOR XML PATH. I... Lee Marks	12-05-2008 07:01 AM Lee Marks	24	286
XQuery sum() function ( 1 2 ) I am having problems getting a sum from xml. The following works and returns - 1150.75 DECLARE @Xml xml SELECT @Xml =... Loren Dummer	12-03-2008 05:40 AM Bob	12	143
insert binary data from xml ( 1 2 3 ) Hi, i have to "bulk" insert in my table some binary values (files) reading from xml text.. i use this way: create table test(MyKey varchar(32),... Gambero	11-26-2008 03:40 PM Gambero	24	294
Shred XML Data into Columns/Rows ( 1 2 3 ) Hello, I have a XML as below. As you may see, the ErrorMessage node has several "Error" nodes with attributes and data. Now, I want to get those... Ganesh Muthuvelu	11-26-2008 07:03 AM Joe Fawcett	24	249

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