这样的一个存储过程
CREATE PROCEDURE Checks_quarterstat2
@S1 INT OUT,
@COUNT1 INT OUT,
@year CHAR(4)
AS
DECLARE
@LS1 CHAR(20),
@LS2 CHAR(20)
SET @LS1 = @year + '-'+'4-1'
SET @LS2 = @year +'-'+'6-30'
SELECT VehicleType, sum(Forfeit),COUNT(CaseNO)
FROM Checks WHERE(RegisterDate BETWEEN CAST(@LS1 AS DATETIME) AND
CAST(@LS2 AS DATETIME)) AND (Status <> 3)
GROUP BY VehicleType
GO
提问:
如果select出的记录不为一条,想把sum()得到的字段值符给@s1,count()得到的字段值符给@count1,生成输出结果,如果直接符值出现错误,怎么操作比较合理。
CREATE PROCEDURE Checks_quarterstat2
@S1 INT OUT,
@COUNT1 INT OUT,
@year CHAR(4)
AS
DECLARE
@LS1 CHAR(20),
@LS2 CHAR(20)
SET @LS1 = @year + '-'+'4-1'
SET @LS2 = @year +'-'+'6-30'
SELECT VehicleType, sum(Forfeit),COUNT(CaseNO)
FROM Checks WHERE(RegisterDate BETWEEN CAST(@LS1 AS DATETIME) AND
CAST(@LS2 AS DATETIME)) AND (Status <> 3)
GROUP BY VehicleType
GO
提问:
如果select出的记录不为一条,想把sum()得到的字段值符给@s1,count()得到的字段值符给@count1,生成输出结果,如果直接符值出现错误,怎么操作比较合理。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货