Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQL Server 2008 Table Valued Parameters

 
Tom Piersa
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I've got a project that I need to call a SQL Server 2008 stored procedure that someone else wrote. I need to pass the stored procedure a User-Defined Table Type as input. I've never done this before. I've searched the internet. I've found lots of examples and articles on how to using C#. But nothing using java. The example in C# listed below breaks things down real simple. I don't know what the equivalent of a C# DataTable is in Java. I've worked with the ResultSet and PreparedStatement data types in java or sure if that's the right direction. I just can't make the connection. Any chance anyone could convert the last yellow box to java?

http://www.codeproject.com/Articles/22392/SQL-Server-2008-Table-Valued-Parameters

Thanks Much,

Tom
 
Campbell Ritchie
Sheriff
Posts: 48402
56
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I think this is too difficult a question for “beginning” and it would sit better in our databases forum.
 
Tom Piersa
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Could you please move it. Not sure if I can do that.

Thanks,

Tom
 
Rob Spoor
Sheriff
Pie
Posts: 20495
54
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Campbell already moved it. In the original forum there is a link to the JDBC forum where the thread is now located.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic