This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes SQL Server 2008 Table Valued Parameters Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "SQL Server 2008 Table Valued Parameters" Watch "SQL Server 2008 Table Valued Parameters" New topic
Author

SQL Server 2008 Table Valued Parameters

Tom Piersa
Greenhorn

Joined: Sep 25, 2009
Posts: 19
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

Joined: Oct 13, 2005
Posts: 37874
    
  22
I think this is too difficult a question for “beginning” and it would sit better in our databases forum.
Tom Piersa
Greenhorn

Joined: Sep 25, 2009
Posts: 19
Could you please move it. Not sure if I can do that.

Thanks,

Tom
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19649
    
  18

Campbell already moved it. In the original forum there is a link to the JDBC forum where the thread is now located.


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
 
 
subject: SQL Server 2008 Table Valued Parameters
 
Similar Threads
"Recordsets" in Java Applets
Stored procedure call removes spaces in text
MS SQL SERVER StTORED PROCEDURE
Problem using Callable Statement
JDBC Stored Procs and Temp tables