Sponsored Links

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

Page 9 of 68

Last »

Threads in Forum : microsoft.public.sqlserver.xml

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
"nodes" is not a valid function, property, or field. I am baffled. I can do exist(), query(), value() but nodes() is not recognized! What am I doing wrong? TIA for any ideas. DECLARE @doc... John	10-12-2007 01:51 PM Kent Tegels	3	119
Predicate value when retrieving a value Is it possible to have the predicate value a variable. Example: DECLARE @XmlData xml ,@Predicate int ,@Value nvarchar... Loren Dummer	10-11-2007 05:16 PM Loren Dummer	2	82
storing xml in a variable I'm trying to return a record as xml and storing it into a variable using sql 2000 Can any one help eg declare @A varchar(2000) set @a = (select *... Erick	10-11-2007 08:53 AM Joe Fawcett	1	100
Update SQL2005 table with XML Performance Has anyone done any performance testing with updating db records via an xml data... Moistly	10-08-2007 10:46 AM Moistly	0	87
Return root tags when there is no row. I'm using For XMl Path() in SQL 2005. When there is no row from the query, it returns nothing, which causes XML serialization failure at .Net side.... Richard	10-06-2007 11:00 PM Han	4	139
Update SQL2005 table with XML? I wish to update a bunch of records in a table with C#/ SQL2005, Usually I would just create a bunch of SQL updates, but ideally would like to do... Moistly	10-05-2007 06:52 AM Moistly	3	94
xml column(s) and performance What is better to have in a table from performance point of view: (a) all data combined in single xml column (b) several xml coulmns where data is... Volodia	10-02-2007 06:16 PM Mike C#	1	139
Re: xml parameter Hello Arne, Use the .WriteXML method on the dataset to spool the serialized set to an instance of SQLXML, then use that as a parameter. Here's a... Kent Tegels	10-02-2007 12:47 PM Kent Tegels	0	102
Load data in xml format into MS SQL Hi, I have problem to load the below xml data using VB 6 into MS SQL server. <?xml version='1.0' encoding='UTF-8'?> <xml> <version>XML date... Yani	10-02-2007 05:50 AM Marc Gravell	1	108
OPENXML - ntext column Hi everyone, I have a problem of converting xml data with ntext type into tabular data. My table is table name: CR1 columns: new_id... DK-IS	09-30-2007 04:13 PM Mike C#	1	104
replace value of method to an empty node I am trying to replace the value of an xml node that is empty. I am using the replace value of method in the sql statement. If the node has a... Loren Dummer	09-29-2007 10:27 AM Joe Fawcett	3	101
Creating Full XML docs from multiple unrelated tables sql 2k I have been researching this for a bit and playing around and have not had much success. Here is the scenario. We have 2 tables bob and jane. Bob... Keith Chadwick	09-28-2007 11:33 AM Keith Chadwick	2	103
How to remove the tag if the value is empty? How can I to remove the tag when the tag value is... ABC	09-28-2007 07:16 AM Martin Honnen	1	102
How to return the xml without empty tag? I want to use simple select statement to return xml, however, the some data is empty values (not Null). I use simple select * for xml statement, it... ABC	09-27-2007 03:40 PM Joe Fawcett	1	150
Parse XML within my T-SQL? Hi, I have some XML stored as a string in my SQL Server 2005 Database. I want to extract the LGD field below as part of my query. How can I do... C	09-26-2007 01:17 PM Joe Fawcett	3	151
Found operand of type 'xdt:anyAtomicType *'. Why?!?! Hi all! With SQL Server 2005... I have an XML and a XSD schema. I create the schema collection into my database. I insert the XML data into the... Axl	09-26-2007 01:00 AM Michael Rys [MSFT]	2	129
Insert data from XML file into MSSQL 2005 ... what's wrong? Hello I have XML file: <?xml version="1.0" encoding="windows-1250" ?> <transfer type="myType" version="1.1"> <header> </header> <body> <entities... aja74	09-26-2007 12:21 AM Michael Rys [MSFT]	1	132
Selecting elements of derived types in SQL Server 2005 XQuery I have a schema that looks something like this (the names have been changed to protect the innocent): <?xml version="1.0"... mkling	09-26-2007 12:17 AM Michael Rys [MSFT]	1	98
how to get table result from mixed source? how can i get relational result set from data coming from both table and attributes of xml? i am new to this. a simple query or step-by-step would... light_wt	09-25-2007 11:44 PM Michael Rys [MSFT]	2	116
need help with xquery value clause I get no error when I use the value clause, but I also get only a return of null. Here is the command exactly as given in the book: SELECT... Bev Kaufman	09-25-2007 11:40 PM Michael Rys [MSFT]	4	119
How to check the Xml value is or not conform the specific xml schema? I want write a function to check xml content with schema, but there are error raise. Create Function IsValidXXXEDIWithSchema ( @XmlContent... ABC	09-25-2007 11:37 PM Michael Rys [MSFT]	1	117
How to know if a column is autoincremental I need to know if the identity column of some table is autoincremental. If anyone can help me... Thanks Hugo Nugra	09-25-2007 06:58 AM Pawel Potasinski	1	164
Altova's v2008 XML product line is available This is just a quick note to announce availability of Altova's 2008 XML product line, which includes Open XML support, C# code gen, and Visual Studio... announce@altova.com	09-24-2007 03:26 PM announce@altova.com	0	123
Need help with xquery order I've already posted this on the XML/General Discussion newsgroup, but didn't get any takers. I'm going to try again here: I am trying to learn... Bev Kaufman	09-20-2007 08:31 PM Bob Beauchemin	1	134
Not authorized to view page Could anyone help me with setting up XML HTTP access on my server? I'm using Windows Server 2003 & MSSQL 2000. Ive used the IIS Virtual Directory... richard@tortoise.demon.co.uk	09-20-2007 06:05 PM richard@tortoise.demon.co.uk	0	151
transfer xml between sql server and .net CLR I am new to xml and finding exactly what I want is hard. I have spent days looking in MSDN and all I can say is just I am a little closer to... elburze	09-20-2007 05:48 AM elburze	2	106
Newbie help with sql xml query I need to get a value from xml data in a sql column. The column is xml data type, below is a sample of the xml data. I am trying to query, and get... A1	09-18-2007 04:39 AM Charles Wang[MSFT]	2	97
make child data unique (sqlxml bulk load) How can i make the child data unique or lets say making it belongs to the... RAVE3110@gmail.com	09-17-2007 10:09 PM RAVE3110@gmail.com	0	191
Repeat column data on other table (sql bulk load) Hi Guys, i have a field named "PersonalNRIC" which i assigned to table SM01_APPLICANT, but in the same time i wanted store the "PersonalNRIC" value... RAVE3110@gmail.com	09-17-2007 05:47 AM RAVE3110@gmail.com	0	91
XML limits in SQL/Server? I'm trying to apply techniques I'd normally use to pull data from SQL/Server to pull XML from SQL/Server, and I'm running into a problem. Here's... Ben	09-17-2007 02:22 AM Charles Wang[MSFT]	4	118
Outputting T-SQL Select query as XML AUTO to a File Running SQL Server 2005. This is more a watch out than a plea for help! I needed to output data from my database in XML format, so I've been... Steve Le Monnier	09-14-2007 08:17 AM Steve Le Monnier	2	1,002
Where to start? I started working on a project that needs to retrieve data from a sql 2005 database where all the columns are xmltypes. I need to get a dataset...	09-13-2007 11:54 AM JXStern	3	146
SQLXML bulk load xml schema with attributes Hi Guys, i cant figure out how to build the xml schema from this xml for sqlxml bulk load. Can anyone enlight me on this? <?xml version="1.0"... RAVE3110@gmail.com	09-13-2007 03:49 AM RAVE3110@gmail.com	0	107
Strip DTD out; Help with some XSLT inside of SSIS XML Task Hello XML Guru's, I hope you guys can help me with something. I've posted this over at the SSIS forum because I am trying to download an XML file... greenmtnsun	09-11-2007 03:22 PM greenmtnsun	0	197
open xml and null datetime I have an xml document with elements containing dates and times. Sometimes the element contents are empty. In this case the datetime value... Jeremy	09-10-2007 10:06 AM Jeremy	1	105
XML data into relational table Hi all! I have an XML like this: <?xml version="1.0" ?> <actions> <action code="ABC1234" number="1"> <group value="2"> <subgroup value="5"> <d... Axl	09-07-2007 03:46 PM Axl	2	94
why conversion error? declare @cid uniqueidentifier declare @pid uniqueidentifier set @cid = '0F88363A-5689-42E1-8A1A-86228B9C23C5' set @pid =... ChrisHarrington	09-07-2007 09:32 AM ChrisHarrington	1	100
How to delete nodes from xml? I want to write a function to delete an node which is specific paremeter from xml. I known it can use @xml.modify to delete, it seems not work... ABC	09-06-2007 07:19 AM Martin Honnen	2	135
Is there any function to check the named tag is exist or not? Is there any function to check the named tag is exist or not? ABC	09-05-2007 11:00 PM	2	184
SQL to XML File Anyone here that also uses ASP pages? I have a stored procedure that creates XML content the way I want it using FOR XML AUTO, ELEMENTS. At least... shank	09-03-2007 03:55 AM Marc Gravell	4	107
create xsd file? Hi, Is there a way that I could generate a XSD file to table mapping? Select * from table1 for xml auto. xmldata -- it also generates the... mecn	08-31-2007 11:37 PM JXStern	4	130
X12/EDI and XML ( 1 2 ) I was asking over in the DTS forum, but this would seem to be the more appropriate group - anybody here doing X12/EDI? Seems like I'm about to! ... JXStern	08-31-2007 11:35 PM JXStern	12	324
namespaces OK, one question, why do I see URLs appearing in namespace definitions? OK, two questions - does that mean my local XML system is going to actually... JXStern	08-31-2007 07:30 AM Martin Honnen	2	100
Query over http virtual directory on win x64 I have been using sqlxml to create virtual directories in IIS for quite some time with great success, but now I'm upgrading to Windows Server 2003... =?Utf-8?B?Q29saW4gQW5kZXJzb24=?=	08-30-2007 08:02 AM =?Utf-8?B?Q29saW4gQW5kZXJzb24=?=	0	93
Include, Import and ReDefine I read somewhere here by one of the members of the engine team that they supported nested schemas but not includes. My problem is I'm about 7... dba	08-28-2007 10:47 PM JXStern	6	171
XML file import to sql 2k table Hi, I ran select top * from table1 for xml auto,xmldata That included the table schema and data in xml format. question on, 1. the table schema in... mecn	08-28-2007 11:48 AM mecn	0	88
using xml format to import data to sql 2k Hi, 1. Instead of text delimiter, an xml format data could imported to sql 2k tables? 2. The same way import text files? --fast and less resource?... mecn	08-28-2007 10:34 AM mecn	8	80
combining data into a single result OK, I'm probably being daft... all I want to do is to (without manual looping) combine (concatenate) the xml from a series of rows: DECLARE @DEMO... Marc Gravell	08-28-2007 09:28 AM Marc Gravell	4	88
Re: Annotated XSD mapping of unary tags Cross post and followup-to microsoft.public.sqlserver.xml as you can more likely find expertise there: Adi wrote: -- Martin Honnen --- MVP... Martin Honnen	08-28-2007 05:54 AM Martin Honnen	0	82
For Xml Explicit Proc Returns int? ( 1 2 ) Hi, I'm trying to get the xml result from a proc using that uses xml explicit and it seems like i'm getting an int back? Why wouldn't I be getting... =?Utf-8?B?TWljaGFlbCBNb3JzZQ==?=	08-23-2007 03:48 PM Peter W. DeBetta	14	172

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