join the MSSQLTips community

MSSQLTips.com - your daily source for SQL Server tips

Google
 
Web mssqltips.com

 
Using Table-Valued Parameters (TVP) in SQL Server 2008 - MSSQLTips

MSSQLTips

MSSQLTips.com - your daily source for SQL Server tips
Welcome to MSSQLTips Sign in | Join | Help
in Search
Home Blogs Forums
MSSQLTips » Tip Forums » Tip Discussions » Using Table-Valued Parameters (TVP) in SQL Server 2008

Using Table-Valued Parameters (TVP) in SQL Server 2008

Last post 04-24-2008 5:55 PM by raybarley. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next

  • 04-23-2008 12:30 AM

    Using Table-Valued Parameters (TVP) in SQL Server 2008

    Reply Contact
    This post is related to this tip: Using Table-Valued Parameters (TVP) in SQL Server 2008

    http://www.mssqltips.com/tip.asp?tip=1483

  • 04-24-2008 3:58 AM In reply to

    Re: Using Table-Valued Parameters (TVP) in SQL Server 2008

    Reply Contact

    This is very intresting article

    I wonder, is it possible to use this type from any client app, like VB.net

    I mean, to fill some structure at client and send it to server in the way, server will undestand like TVP parameter

    ( ado object or array or what?)I tied to do it, and always got error - varchar is not comatible with table type

  • 04-24-2008 5:55 PM In reply to

    Re: Using Table-Valued Parameters (TVP) in SQL Server 2008

    Reply Contact

     Yes.  Here are the links to Books on LIne:

    ODBC - http://technet.microsoft.com/en-us/library/bb522663(SQL.100).aspx

    OLEDB - http://technet.microsoft.com/en-us/library/bb510472(SQL.100).aspx

     
Page 1 of 1 (3 items)
Copyright (c) 2006-2010 Edgewood Solutions, LLC All rights reserved | privacy statement | disclaimer | copyright