Wednesday, August 7, 2013

Solving com.microsoft.sqlserver.jdbc.sqlserverexception the result set was generated for update

To solve the following issue,
"com.microsoft.sqlserver.jdbc.sqlserverexception the result set was generated for update"

add the following code to your Stored Procedure/SQL script.

SET COUNT OFF