• 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
Marshal
Posts: 53138
124
  • 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
Posts: 20827
68
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.
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!