http://www.sqlmag.com/authors/author/author/5777608/rsscomment/5777608en-USFri, 25 May 2012 08:54:31 GMTFri, 25 May 2012 08:54:31 GMThttp://www.sqlmag.com/article/tsql3/on-the-edge#commentsAnchorFri, 06 Apr 2012 08:14:58 GMT
hello sir i want to know more about the working of edge can you help me in that i need your email id to ask you some questions may i ?]]>Aakash GuptaFri, 06 Apr 2012 08:14:58 GMThttp://www.sqlmag.com/article/tsql3/on-the-edge#commentsAnchorhttp://www.sqlmag.com/article/internet/selecting-xml-technologies-for-queries-and-updates#commentsAnchorThu, 18 Sep 2008 03:14:16 GMT
I wanted to learn how to update an xml tree. This is just an old overview of tech]]>PatrikThu, 18 Sep 2008 03:14:16 GMThttp://www.sqlmag.com/article/internet/selecting-xml-technologies-for-queries-and-updates#commentsAnchorhttp://www.sqlmag.com/article/stored-procedures/overcoming-openxml-hangups#commentsAnchorThu, 18 Sep 2008 03:11:33 GMT
Was exactly what I was looking for. Maybe it could be updated for sqlserver 2008.]]>PatrikThu, 18 Sep 2008 03:11:33 GMThttp://www.sqlmag.com/article/stored-procedures/overcoming-openxml-hangups#commentsAnchorhttp://www.sqlmag.com/article/tsql3/openxml-s-mp-id-meta-property#commentsAnchorTue, 19 Feb 2008 17:34:09 GMT
P.S. andy.hart@claybrook.co.uk comment is absolultely relevant... without the steps he mentioned, the procedure is useless in real world!]]>MiroslavTue, 19 Feb 2008 17:34:09 GMThttp://www.sqlmag.com/article/tsql3/openxml-s-mp-id-meta-property#commentsAnchorhttp://www.sqlmag.com/article/tsql3/openxml-s-mp-id-meta-property#commentsAnchorTue, 19 Feb 2008 16:48:13 GMT
Brilliant!]]>MiroslavTue, 19 Feb 2008 16:48:13 GMThttp://www.sqlmag.com/article/tsql3/openxml-s-mp-id-meta-property#commentsAnchorhttp://www.sqlmag.com/article/tsql3/openxml-s-mp-id-meta-property#commentsAnchorMon, 14 May 2007 08:25:50 GMT
I have a couple of issues with this approach: Concurrency & Data Integrity: executing the stored procedure simultaneously by mupltiple users (with different xml documents) would give unexpected results due to the clashing of ImportIDs between the different sessions. This could be avoided by wrapping the work done by the stored procedure in one transaction so that other sessions would only see their own data when inserting the Line Item rows. The stored procedure would also need to then set all the ImportIDs to NULL in the Order table so that they will not later clash with other inserts.]]>andy.hart@claybrook.co.uk Mon, 14 May 2007 08:25:50 GMThttp://www.sqlmag.com/article/tsql3/openxml-s-mp-id-meta-property#commentsAnchorhttp://www.sqlmag.com/article/internet/creating-a-web-service#commentsAnchorSun, 03 Jul 2005 15:52:43 GMT
I haven’t got "soap" as an option in the "type" drop down box. Only dbobject, schema or template. Regardless of what I select no files are created in the VD. If anyone out there is reading and knows how to fix I’d like to get a handle on this set-up. Cheers Jay. qpr@xtra dot co dot nz]]>Anonymous User Sun, 03 Jul 2005 15:52:43 GMThttp://www.sqlmag.com/article/internet/creating-a-web-service#commentsAnchorhttp://www.sqlmag.com/article/tsql3/openxml-s-mp-id-meta-property#commentsAnchorSun, 05 Jun 2005 10:27:49 GMT
example of declare in an application HOW TO: Perform Bulk Updates and Inserts Using OpenXML with .NET Providers in Visual C# .NET http://support.microsoft.com/default.aspx?scid=kb;en-us;315968 ]]>Anonymous User Sun, 05 Jun 2005 10:27:49 GMThttp://www.sqlmag.com/article/tsql3/openxml-s-mp-id-meta-property#commentsAnchorhttp://www.sqlmag.com/article/tsql3/openxml-s-mp-id-meta-property#commentsAnchorSun, 05 Jun 2005 09:52:32 GMT
The OpenXML statement specifies the reference to the document in the variable @doc and specifies the XPath query //Order as the row selector. Must declare the variable ’@iDoc’. ]]>Anonymous User Sun, 05 Jun 2005 09:52:32 GMThttp://www.sqlmag.com/article/tsql3/openxml-s-mp-id-meta-property#commentsAnchorhttp://www.sqlmag.com/article/internet/using-xml-bulk-load-to-invoke-a-stored-procedure#commentsAnchorTue, 04 Jan 2005 10:13:49 GMT
I’m trying to load XML into my SQL database. I like to use XML Bulk Load, but how do I write in C++ to execute the XML Bulk Load to create temporary tables.]]>Anonymous User Tue, 04 Jan 2005 10:13:49 GMThttp://www.sqlmag.com/article/internet/using-xml-bulk-load-to-invoke-a-stored-procedure#commentsAnchorhttp://www.sqlmag.com/article/internet/using-xml-bulk-load-to-invoke-a-stored-procedure#commentsAnchorTue, 28 Dec 2004 23:28:34 GMT
How to import the XML files saved in diff drives by using SQL Server DTS packages and user defined procedures without using VB and .NET coading]]>Anonymous User Tue, 28 Dec 2004 23:28:34 GMThttp://www.sqlmag.com/article/internet/using-xml-bulk-load-to-invoke-a-stored-procedure#commentsAnchorhttp://www.sqlmag.com/article/quering/using-java-to-retrieve-xml-from-sql-server#commentsAnchorThu, 23 Dec 2004 08:59:07 GMT
Very helpful]]>Anonymous User Thu, 23 Dec 2004 08:59:07 GMThttp://www.sqlmag.com/article/quering/using-java-to-retrieve-xml-from-sql-server#commentsAnchorhttp://www.sqlmag.com/article/tsql3/using-xml-bulk-load-with-identity-columns#commentsAnchorThu, 29 Jul 2004 07:10:28 GMT
The example does not work :(]]>ZACHARThu, 29 Jul 2004 07:10:28 GMThttp://www.sqlmag.com/article/tsql3/using-xml-bulk-load-with-identity-columns#commentsAnchorhttp://www.sqlmag.com/article/tsql3/yukon-s-xml-data-type#commentsAnchorThu, 03 Jun 2004 17:38:45 GMT
Would you please answer to my question or refer articles ? 1. If XSD is created in SQL server database by "CREATE XMLSCHEMA schema_string", where is the metadata saved? In some system table in master database? So can we retriev the schema later by quering from system table? 2. If XMLSCHEMA is modified after created and used for certain xml column, how about existing xml data in the table? Is there any enforcing rule for xml type data integration? By the way, this article was very informative. Thanks.]]>Sylvia Chung Thu, 03 Jun 2004 17:38:45 GMThttp://www.sqlmag.com/article/tsql3/yukon-s-xml-data-type#commentsAnchorhttp://www.sqlmag.com/article/quering/exploring-xml21691#commentsAnchorWed, 26 May 2004 07:04:07 GMT
In your sample is missing root element in SQL result.]]>Former SSman Wed, 26 May 2004 07:04:07 GMThttp://www.sqlmag.com/article/quering/exploring-xml21691#commentsAnchorhttp://www.sqlmag.com/article/xml/xml-q-a20036#commentsAnchorMon, 01 Mar 2004 10:32:27 GMT
Article: XML Q & A, Date: May 2001 by Rich Rollamn, Figure 2 and Web Listing 1 doesn’t work for me. I wonder if I need to do some thing more or do you have another solution to this case (except for xml explicit). Best regards Francisco Rubiano]]>Francisco Rubiano Mon, 01 Mar 2004 10:32:27 GMThttp://www.sqlmag.com/article/xml/xml-q-a20036#commentsAnchorhttp://www.sqlmag.com/article/quering/using-java-to-retrieve-xml-from-sql-server#commentsAnchorMon, 23 Feb 2004 22:22:23 GMT
Dear Sir I need your help so much. i am using sqlxmlbulkload to map from xml to sql server. i am trying to make identity increment coulmn but i can not , beside i need to make more than 1 relation between 2 tables sql:relationship, but i can not. can you help please]]>mostafa salama Mon, 23 Feb 2004 22:22:23 GMThttp://www.sqlmag.com/article/quering/using-java-to-retrieve-xml-from-sql-server#commentsAnchorhttp://www.sqlmag.com/article/quering/using-java-to-retrieve-xml-from-sql-server#commentsAnchorSun, 22 Feb 2004 19:18:40 GMT
This article was of grt value to me since I was facing a similar dilemma. thanks]]>sridhars Sun, 22 Feb 2004 19:18:40 GMThttp://www.sqlmag.com/article/quering/using-java-to-retrieve-xml-from-sql-server#commentsAnchorhttp://www.sqlmag.com/article/internet/creating-a-web-service#commentsAnchorTue, 19 Nov 2002 00:44:36 GMT
I get the error: "The input parameter ’CID’ to the stored procedure called]]>Hemy Tue, 19 Nov 2002 00:44:36 GMThttp://www.sqlmag.com/article/internet/creating-a-web-service#commentsAnchorhttp://www.sqlmag.com/article/xml/xml-q-a20036#commentsAnchorThu, 07 Mar 2002 03:21:06 GMT
Please could Rich Rollmann add sammple code which one can straitly test in the northwind or pubs database. Here in this example he demoes examples with an organisation table for which he doesn’t supply DDL statements. It would be much easier to follow if he would supply some ddl code to be able to build the sample and to practice with his sample code. Thanks Michael]]>Michael Wolff Thu, 07 Mar 2002 03:21:06 GMThttp://www.sqlmag.com/article/xml/xml-q-a20036#commentsAnchorhttp://www.sqlmag.com/article/quering/using-java-to-retrieve-xml-from-sql-server#commentsAnchorThu, 10 Jan 2002 20:01:50 GMT
Hi, I tried to compile the code in Listing 1. I got the following error message. JDBCSQL.java:54: cannot resolve symbol symbol : variable sb location: class jdbcsql.JDBCSQL sb.append((char) c); ^ 1 error Thanks for any suggestions. Ram]]>ramThu, 10 Jan 2002 20:01:50 GMThttp://www.sqlmag.com/article/quering/using-java-to-retrieve-xml-from-sql-server#commentsAnchor