语句在sql sever中执行正常，在java中提示无返回结果集，但是使用SET NOCOUNT ON依然提示无返回结果集

Question

语句在sql sever中执行正常，在java中提示无返回结果集，但是使用SET NOCOUNT ON依然提示无返回结果集
语句：
declare @i
varchar(max) set @i=1

while @i<(select count(GSID)+1 from CP_JTGS where JTID=(select id from CP_jituan where jickm=10014))
begin
SET NOCOUNT ON

insert INTO ERA_Account(id,code,name,CorpId) values((select max(id) from ERA_Account)+@i,'1001','现金',(select Corpid from (SELECT ROW_NUMBER() OVER(ORDER BY Corpid) ROWNU,Corpid FROM (select GSID as Corpid from CP_JTGS where JTID=(select id from CP_jituan where jickm=10014)) as a) as b where ROWNU=@i))
SET @i=@i+1

end

Answer 1

https://blog.csdn.net/wulm1315/article/details/39474249