aspose file tools
The moose likes JDBC and Relational Databases 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
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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: 41999
    
  31
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: 19971
    
  25

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 - OCEJPAD 6
How To Ask Questions How To Answer Questions
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: SQL Server 2008 Table Valued Parameters