<div>
I just use PreparedStatements with MySQL and Postgres<br />
<br />
Maybe that works in MSSQL as well (I've never tried)<br />
<br />
&nbsp; &nbsp; &nbsp;prepareStatement( &nbsp;&quot;CALL my_function( ?, ? )&quot; ) ;<br />
<br />
for example...
</div>


I just use PreparedStatements with MySQL and Postgres

Maybe that works in MSSQL as well (I've never tried)

     prepareStatement(  "CALL my_function( ?, ? )" ) ;

for example...

<div>
Thanks a lot, folks. &nbsp;Works very nicely.
</div>


Thanks a lot, folks.  Works very nicely.

<div>
<div class="content wysiwyg-content">
Dear Experts,<br />
<br />
Due to technical difficulties, I'm trying to circumvent a PreparedStatement and instead generate and use an MS SQL stored procedure directly. &nbsp;However, I've never done it in Java.<br />
<br />
I know how to write the stored procedure itself. &nbsp;But what is the preferred syntax (other than PreparedStatement) to call it and return the ResultSet?<br />
<br />
Thanks!<br />
BrianMc1958
</div>
</div>


Dear Experts,

Due to technical difficulties, I'm trying to circumvent a PreparedStatement and instead generate and use an MS SQL stored procedure directly.  However, I've never done it in Java.

I know how to write the stored procedure itself.  But what is the preferred syntax (other than PreparedStatement) to call it and return the ResultSet?

Thanks!
BrianMc1958

Best practice for getting ResultSet from MS SQL stored procedure?

Java is a platform-independent, object-oriented programming language and run-time environment, designed to have as few implementation dependencies as possible such that developers can write one set of code across all platforms using libraries. Most devices will not run Java natively, and require a run-time component to be installed in order to execute a Java program.