<?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>Introducing Table-Valued Parameters - Part 1</title><link>http://blogs.msdn.com/adonet/archive/2008/08/15/introducing-table-valued-parameters-part-1.aspx</link><description>Hey everyone! I am Himanshu. I am a program manager in the ADO.Net team. Today I am going to talk about Table-Valued parameters that are new in SQL Server 2008. About 4 years back I was writing an application which involved adding metadata about my music</description><dc:language>en</dc:language><generator>CommunityServer 2.1 SP1 (Build: 61025.2)</generator><item><title>discount furniture &amp;raquo; Introducing Table-Valued Parameters - Part 1</title><link>http://blogs.msdn.com/adonet/archive/2008/08/15/introducing-table-valued-parameters-part-1.aspx#8871017</link><pubDate>Sat, 16 Aug 2008 02:52:03 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8871017</guid><dc:creator>discount furniture &amp;raquo; Introducing Table-Valued Parameters - Part 1</dc:creator><description>&lt;p&gt;PingBack from &lt;a rel="nofollow" target="_new" href="http://informationsfunnywallpaper.cn/?p=866"&gt;http://informationsfunnywallpaper.cn/?p=866&lt;/a&gt;&lt;/p&gt;
</description></item><item><title>re: Introducing Table-Valued Parameters - Part 1</title><link>http://blogs.msdn.com/adonet/archive/2008/08/15/introducing-table-valued-parameters-part-1.aspx#8871054</link><pubDate>Sat, 16 Aug 2008 03:19:11 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8871054</guid><dc:creator>wisemx</dc:creator><description>&lt;p&gt;Thanks Himanshu...&lt;/p&gt;
&lt;p&gt;Keep me posted and I'll create a series of Silverlight streaming Webcasts for these.&lt;/p&gt;
&lt;p&gt; &amp;nbsp;Salute,&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;Mark Wisecarver&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;Technical Evangelist&lt;/p&gt;
</description></item><item><title>re: Introducing Table-Valued Parameters - Part 1</title><link>http://blogs.msdn.com/adonet/archive/2008/08/15/introducing-table-valued-parameters-part-1.aspx#8871192</link><pubDate>Sat, 16 Aug 2008 05:21:54 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8871192</guid><dc:creator>Michael O'Neill</dc:creator><description>&lt;p&gt;This sounds like a better feature than it will turn out to be in the end. &amp;nbsp;I remember when Oracle introduced this feature a decade ago and it just never became a common feature to use in all that time.&lt;/p&gt;
</description></item><item><title>re: Introducing Table-Valued Parameters - Part 1</title><link>http://blogs.msdn.com/adonet/archive/2008/08/15/introducing-table-valued-parameters-part-1.aspx#8871482</link><pubDate>Sat, 16 Aug 2008 13:45:12 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8871482</guid><dc:creator>BlackTiger</dc:creator><description>&lt;p&gt;1. You deserve to ... for such feature&lt;/p&gt;
&lt;p&gt;2. How to work with this...feature from .NET?&lt;/p&gt;
&lt;p&gt;3. Some &amp;quot;smarties&amp;quot; used such feature in some Oracle app. And I was involved to build .NET &amp;quot;bridge&amp;quot; for it... It was a disaster...&lt;/p&gt;
</description></item><item><title>re: Introducing Table-Valued Parameters - Part 1</title><link>http://blogs.msdn.com/adonet/archive/2008/08/15/introducing-table-valued-parameters-part-1.aspx#8876271</link><pubDate>Mon, 18 Aug 2008 14:26:36 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8876271</guid><dc:creator>danieldsmith</dc:creator><description>&lt;p&gt;Table Valued Parameters are incredibly useful. &amp;nbsp;We have a number of apps where we previously had to pass in comma separated lists of IDs (e.g. list of Customer IDs) and then parse the strings and turn them into temporary tables so we could do joins on them.&lt;/p&gt;
&lt;p&gt;It would be really neat if there were some built in tables types defined so we didn't have to create types like these every time:&lt;/p&gt;
&lt;p&gt;CREATE TYPE IntList_TableType AS TABLE (ID int not null)&lt;/p&gt;
&lt;p&gt;CREATE TYPE BigIntList_TableType AS TABLE (ID bigint not null)&lt;/p&gt;
</description></item><item><title>Interesting Finds: 2008.08.13~2008.08.21</title><link>http://blogs.msdn.com/adonet/archive/2008/08/15/introducing-table-valued-parameters-part-1.aspx#8884476</link><pubDate>Thu, 21 Aug 2008 14:07:36 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8884476</guid><dc:creator>gOODiDEA</dc:creator><description>&lt;p&gt;.NETTCP:BufferManagementASP.NetLoadTestingandOptimizationToolkit-Soyouwanttobeahe...&lt;/p&gt;
</description></item><item><title>Interesting Finds: 2008.08.13~2008.08.21</title><link>http://blogs.msdn.com/adonet/archive/2008/08/15/introducing-table-valued-parameters-part-1.aspx#8884484</link><pubDate>Thu, 21 Aug 2008 14:09:23 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8884484</guid><dc:creator>gOODiDEA.NET</dc:creator><description>&lt;p&gt;.NET TCP: Buffer Management ASP.Net Load Testing and Optimization Toolkit - So you want to be a hero&lt;/p&gt;
</description></item><item><title>re: Introducing Table-Valued Parameters - Part 1</title><link>http://blogs.msdn.com/adonet/archive/2008/08/15/introducing-table-valued-parameters-part-1.aspx#8956891</link><pubDate>Thu, 18 Sep 2008 10:34:45 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8956891</guid><dc:creator>John</dc:creator><description>&lt;p&gt;Hi,&lt;/p&gt;
&lt;p&gt;Thanks Himanshu for your ideas and codings. Me too finished my .NET course and plan to do a project using ADO.NET. I think your sql parameters surely will help me out in my project to execute well.&lt;/p&gt;
&lt;p&gt;Thank you very much...&lt;/p&gt;
&lt;p&gt;--------------------&lt;/p&gt;
&lt;p&gt;John&lt;/p&gt;
&lt;p&gt;&amp;lt;a href=&amp;quot;&lt;a rel="nofollow" target="_new" href="http://www.widecircles.ca&amp;quot;&amp;gt;Wide"&gt;http://www.widecircles.ca&amp;quot;&amp;gt;Wide&lt;/a&gt; Circles&amp;lt;/a&amp;gt; &lt;/p&gt;
</description></item><item><title>re: Introducing Table-Valued Parameters - Part 1</title><link>http://blogs.msdn.com/adonet/archive/2008/08/15/introducing-table-valued-parameters-part-1.aspx#9372954</link><pubDate>Fri, 23 Jan 2009 21:03:21 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:9372954</guid><dc:creator>cozqzrxqd</dc:creator><description>&lt;p&gt;IDCzFx &amp;nbsp;&amp;lt;a href=&amp;quot;&lt;a rel="nofollow" target="_new" href="http://kklmaanqjbgq.com/&amp;quot;&amp;gt;kklmaanqjbgq&amp;lt;/a&amp;gt;"&gt;http://kklmaanqjbgq.com/&amp;quot;&amp;gt;kklmaanqjbgq&amp;lt;/a&amp;gt;&lt;/a&gt;, [url=&lt;a rel="nofollow" target="_new" href="http://oenzopxvjrfp.com/"&gt;http://oenzopxvjrfp.com/&lt;/a&gt;]oenzopxvjrfp[/url], [link=&lt;a rel="nofollow" target="_new" href="http://rqccweciopkk.com/"&gt;http://rqccweciopkk.com/&lt;/a&gt;]rqccweciopkk[/link], &lt;a rel="nofollow" target="_new" href="http://hasqfgeztdzw.com/"&gt;http://hasqfgeztdzw.com/&lt;/a&gt;&lt;/p&gt;
</description></item><item><title>re: Introducing Table-Valued Parameters - Part 1</title><link>http://blogs.msdn.com/adonet/archive/2008/08/15/introducing-table-valued-parameters-part-1.aspx#9483114</link><pubDate>Tue, 17 Mar 2009 12:35:08 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:9483114</guid><dc:creator>Rukshan</dc:creator><description>&lt;p&gt;when you define a table,what are main parameters that you are considering? plese send a anser from mail to dewamax@gamil.com&lt;/p&gt;
</description></item></channel></rss>