Is there a way to set the size of ResultSet from MS SQL Server

[Daxin Zuo]

I use JDBC in JSP/Java with MS SQL Server.
Is there a way to set the Fetch Size (set to 10, 100,..) of ResultSet (as
ADO CacheSize  in ASP)?

With Oracle, we can set it in program.

Thanks.



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]