java 没有返回结果集_SQL存储过程在查询分析工具中正常……在JAVA中运行提示该语句没有返回结果集。...

RT以下是存储过程CREATEPROCEDUREap_SetOutputVar@countintegerOUTPUTASSETNOCOUNTON;SELECT@count=count(*)FROMtestGO以下是报错atcom.microsoft.sqlserver.jdbc.SQLServerException...

RT

以下是存储过程

CREATE PROCEDURE ap_SetOutputVar @count integer OUTPUT

AS

SET NOCOUNT ON;

SELECT @count = count(*) FROM test

GO

以下是报错

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)

at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source)

at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(Unknown Source)

at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(Unknown Source)

at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(Unknown Source)

at

求大神指导……

展开