Click here to Skip to main content
Search within:



Next

Table Valued Parameter
Sign Up to vote bad
good
See more: SQL-Server
Dear Folks..
 
Is it possible to pass DataTable with 16 column to Stored Procedure as Table Valued Parameter..
 
Thanks & Regards
Kanag.M
Posted 25 Feb '13 - 5:59
kanagmathes618
Add a Solution


2 solutions

Yes.
.http://msdn.microsoft.com/en-us/library/bb510489.aspx[^]
http://www.sommarskog.se/share_data.html[^]
 
You could also pass an XML and convert that to a table inside the proc.
http://msdn.microsoft.com/en-us/library/ms345117(SQL.90).aspx[^]
  Permalink  
Posted 25 Feb '13 - 6:09
BC @ CV2.5K
Edited 25 Feb '13 - 6:17
v3
Read this Q-A session from our CP portal
 
Passing Datatable Parameter to Stored Procedure[^]
 

Hope this helps
--RDBurmon
  Permalink  
Posted 25 Feb '13 - 6:13
RDBurmon8.3K
Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Your Filters
Interested
Ignored
     
0 Sergey Alexandrovich Kryukov 496
1 Mahesh Bailwal 342
2 Maciej Los 228
3 Aarti Meswania 215
4 Arun Vasu 174
0 Sergey Alexandrovich Kryukov 9,607
1 OriginalGriff 7,214
2 CPallini 3,943
3 Rohan Leuva 3,261
4 Maciej Los 2,758


Advertise | Privacy | Mobile
Web04 | 2.6.130516.1 | Last Updated 25 Feb 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid