CREATE PROCEDURE UserSign
ASdeclare @start DATETIME
declare @end DATETIME
declare @start1 DATETIMEset @start=CAST('2007-07-06' AS DATETIME)
set @end=CAST('2007-07-31' AS DATETIME)while(@start<=@end)
BEGINset @start1=DATEADD(day,1,@start)
select * from UserTable ut left outer join (select * from [PersonSignIn/OutTable]
where SignTimeM >= @start AND SignTimeM <= @start1) pt on ut.UserId=pt.SignPersonIdset @start=DATEADD(day,1,@start)
if(@start>@end)
break
else
continue
end=========================================
存储过程创建完后
用
cstmt = con.prepareCall("{call "+procStr+ "}");
ResultSet rs =rs = cstmt.executeQuery();得到了结果只显示了第1组数据(存储过程执行结果集的第1个循环的数据)其他的循环的数据没有得到
请问各位如何解决
ASdeclare @start DATETIME
declare @end DATETIME
declare @start1 DATETIMEset @start=CAST('2007-07-06' AS DATETIME)
set @end=CAST('2007-07-31' AS DATETIME)while(@start<=@end)
BEGINset @start1=DATEADD(day,1,@start)
select * from UserTable ut left outer join (select * from [PersonSignIn/OutTable]
where SignTimeM >= @start AND SignTimeM <= @start1) pt on ut.UserId=pt.SignPersonIdset @start=DATEADD(day,1,@start)
if(@start>@end)
break
else
continue
end=========================================
存储过程创建完后
用
cstmt = con.prepareCall("{call "+procStr+ "}");
ResultSet rs =rs = cstmt.executeQuery();得到了结果只显示了第1组数据(存储过程执行结果集的第1个循环的数据)其他的循环的数据没有得到
请问各位如何解决
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货