使用临时表拼接两张表数据,并查询结果集,存储过程代码如下:
ALTER PROCEDURE dead_proc AS
BEGIN
SELECT * INTO #deadTemp FROM deadNum;
INSERT into #deadTemp SELECT * FROM deadNum2;
SELECT * FROM #deadTemp ;
END;
java调用该存储过程,代码如下(略去数据库连接部分):
conn = ConnUtils.getConnection();
statement = conn.prepareCall("{call dead_proc}");
ResultSet resultSet=statement.executeQuery();
int ID,num;
Date time;
System.out.println("数据库内容:");
while (resultSet!=null&&resultSet.next()){
ID=resultSet.getInt("ID");
num=resultSet.getInt("num");
time=resultSet.getDate("time");
System.out.println(ID+" "+num+" "+time);
}
运行后报出错误信息
com.microsoft.sqlserver.jdbc.SQLServerException: 该语句没有返回结果集。
at com.microsoft.sqlse