<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://blogs.msdn.com/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Using SQLXML's at-identity with BizTalk</title><link>http://blogs.msdn.com/skaufman/archive/2005/01/31/363920.aspx</link><description>I was looking for a way to send data to SQL Server to populate multiple tables in a parent-child relationship without the need to make additional roundtrips. What I describe below is the solution that I put together. The first thing that I found was that</description><dc:language>en-US</dc:language><generator>CommunityServer 2.1 SP1 (Build: 61025.2)</generator><item><title>re: Using SQLXML's at-identity with BizTalk</title><link>http://blogs.msdn.com/skaufman/archive/2005/01/31/363920.aspx#363957</link><pubDate>Mon, 31 Jan 2005 21:15:00 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:363957</guid><dc:creator>Nabeel Prior</dc:creator><description>Thanks for wording this so clearly.  I have been using this technique for a while, and it works wonderfully.  One thing I have been struggling with, however, is how to return the identity of an inserted record in the response schema (i.e. return more than just a boolean field).  Have you tried this, or got a solution for this?</description></item><item><title>Using SQLXML's at-identity with BizTalk 2004 (UpdateGram)</title><link>http://blogs.msdn.com/skaufman/archive/2005/01/31/363920.aspx#364542</link><pubDate>Tue, 01 Feb 2005 17:32:00 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:364542</guid><dc:creator>Robert Rijsdijk's BizTalk Server Weblogs</dc:creator><description /></item><item><title>How to insert values into 2 tables and link them in Biztalk</title><link>http://blogs.msdn.com/skaufman/archive/2005/01/31/363920.aspx#412122</link><pubDate>Tue, 26 Apr 2005 16:13:17 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:412122</guid><dc:creator>Bogdan Nedelcu - my blog</dc:creator><description>A very good article about how to insert values into two tables through Biztalk. It helped me a lot....</description></item><item><title>SQL Updategrams (Insert/Update/Delete) in BizTalk: Part II</title><link>http://blogs.msdn.com/skaufman/archive/2005/01/31/363920.aspx#433546</link><pubDate>Wed, 29 Jun 2005 00:47:36 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:433546</guid><dc:creator>Richard Seroter - SoCal BPI Musings</dc:creator><description>&lt;br&gt;Yesterday (see Part I) we looked at the first part of a BizTalk and SQL Server updategram project....</description></item><item><title>Populate multiple tables in a parent-child relationship in one roundtrip (Inserting Data by Using XML Updategrams)</title><link>http://blogs.msdn.com/skaufman/archive/2005/01/31/363920.aspx#572805</link><pubDate>Tue, 11 Apr 2006 00:20:11 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:572805</guid><dc:creator>BizTalk Blog by Chris Han</dc:creator><description /></item><item><title>Inserting into multiple tables with multiple Pk/Fk relationships</title><link>http://blogs.msdn.com/skaufman/archive/2005/01/31/363920.aspx#4114811</link><pubDate>Sun, 29 Jul 2007 10:16:01 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:4114811</guid><dc:creator>Eric's BizTalk 2004/2006 blog</dc:creator><description>&lt;p&gt;Inserting into multiple tables with multiple Pk/Fk relationships&lt;/p&gt;
</description></item><item><title>Stephen Kaufman's WebLog : Using SQLXML's at-identity with BizTalk</title><link>http://blogs.msdn.com/skaufman/archive/2005/01/31/363920.aspx#8566210</link><pubDate>Sat, 31 May 2008 12:34:39 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8566210</guid><dc:creator>Dating</dc:creator><description>&lt;p&gt;I was looking for a way to send data to SQL Server to populate multiple tables in a parent-child relationship without the need to make additional roundtrips. What I describe below is the solution that I put together. The first thing that I found was tha&lt;/p&gt;
</description></item><item><title>Stephen Kaufman's WebLog : Using SQLXML's at-identity with BizTalk</title><link>http://blogs.msdn.com/skaufman/archive/2005/01/31/363920.aspx#8577135</link><pubDate>Fri, 06 Jun 2008 10:04:12 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8577135</guid><dc:creator>Weddings</dc:creator><description>&lt;p&gt;I was looking for a way to send data to SQL Server to populate multiple tables in a parent-child relationship without the need to make additional roundtrips. What I describe below is the solution that I put together. The first thing that I found was tha&lt;/p&gt;
</description></item><item><title>Validating Schemas During Runtime</title><link>http://blogs.msdn.com/skaufman/archive/2005/01/31/363920.aspx#8749677</link><pubDate>Fri, 18 Jul 2008 18:02:23 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8749677</guid><dc:creator>Stephen Kaufman's WebLog</dc:creator><description>&lt;p&gt;I recently came across an interesting scenario. In my application, we are transforming multiple incoming&lt;/p&gt;
</description></item><item><title> Stephen Kaufman s WebLog Using SQLXML s at identity with BizTalk | Paid Surveys</title><link>http://blogs.msdn.com/skaufman/archive/2005/01/31/363920.aspx#9683975</link><pubDate>Tue, 02 Jun 2009 09:59:08 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:9683975</guid><dc:creator> Stephen Kaufman s WebLog Using SQLXML s at identity with BizTalk | Paid Surveys</dc:creator><description>&lt;p&gt;PingBack from &lt;a rel="nofollow" target="_new" href="http://paidsurveyshub.info/story.php?id=76003"&gt;http://paidsurveyshub.info/story.php?id=76003&lt;/a&gt;&lt;/p&gt;
</description></item></channel></rss>