How Would You Use Table Valued Parameters (TVP)?

Published Mar 23 2019 12:46 PM 177 Views
Microsoft
First published on MSDN on Apr 03, 2012

Many of you have asked for Table Valued Parameters (TVP) support in the Microsoft JDBC Driver for SQL Server.  We have added TVP support to our roadmap and are gathering requirements (we don’t have an availability date yet).



We would like to hear more details about how you would use TVP’s and how TVP’s will benefit your organization.  Many of you have told us that you currently pass structured data to SQL Server/SQL Azure using XML but we would like more
specifics.



Can you share snippets or samples of your existing code that you would like to retool to use TVP’s? Can you provide more details on how TVP’s will help you or your organization?



You can email us or comment on this blog.



Thanks,


Shamitha Reddy


Program Manager – Microsoft JDBC Driver for SQL Server



For technical support, please use our forums .

%3CLINGO-SUB%20id%3D%22lingo-sub-384082%22%20slang%3D%22en-US%22%3EHow%20Would%20You%20Use%20Table%20Valued%20Parameters%20(TVP)%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-384082%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3E%20First%20published%20on%20MSDN%20on%20Apr%2003%2C%202012%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%3CP%3EMany%20of%20you%20have%20asked%20for%20Table%20Valued%20Parameters%20(TVP)%20support%20in%20the%20Microsoft%20JDBC%20Driver%20for%20SQL%20Server.%26nbsp%3B%20We%20have%20added%20TVP%20support%20to%20our%20roadmap%20and%20are%20gathering%20requirements%20(we%20don%E2%80%99t%20have%20an%20availability%20date%20yet).%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EWe%20would%20like%20to%20hear%20more%20details%20about%20how%20you%20would%20use%20TVP%E2%80%99s%20and%20how%20TVP%E2%80%99s%20will%20benefit%20your%20organization.%26nbsp%3B%20Many%20of%20you%20have%20told%20us%20that%20you%20currently%20pass%20structured%20data%20to%20SQL%20Server%2FSQL%20Azure%20using%20XML%20but%20we%20would%20like%20more%20%3CBR%20%2F%3E%20specifics.%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3ECan%20you%20share%20snippets%20or%20samples%20of%20your%20existing%20code%20that%20you%20would%20like%20to%20retool%20to%20use%20TVP%E2%80%99s%3F%26nbsp%3BCan%20you%20provide%20more%20details%20on%20how%20TVP%E2%80%99s%20will%20help%20you%20or%20your%20organization%3F%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EYou%20can%20%3CA%20href%3D%22mailto%3A%2520%2520msjdbc%40microsoft.com%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20email%20%3C%2FA%3E%20us%20or%20comment%20on%20this%20blog.%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EThanks%2C%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EShamitha%20Reddy%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EProgram%20Manager%20%E2%80%93%20Microsoft%20JDBC%20Driver%20for%20SQL%20Server%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EFor%20technical%20support%2C%20please%20use%20our%20%3CA%20href%3D%22http%3A%2F%2Fsocial.msdn.microsoft.com%2Fforums%2Fen-US%2Fsqldataaccess%2Fthreads%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20forums%20%3C%2FA%3E%20.%3C%2FP%3E%0A%20%0A%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-384082%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20Apr%2003%2C%202012%20Many%20of%20you%20have%20asked%20for%20Table%20Valued%20Parameters%20(TVP)%20support%20in%20the%20Microsoft%20JDBC%20Driver%20for%20SQL%20Server.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-384082%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQLServerDrivers%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Mar 23 2019 12:46 PM
Updated by: