执行存储过程出错？

Question

/*CREATE PROCEDURE SP_ShowLeaveSummary
@start DATETIME,
@end DATETIME
AS
BEGIN
SELECT a.EmployeeID,a.EmployeeName,ISNULL(b.LeaveCount,0) LeaveCount,
ISNULL(b.LeaveTotalHours,0) LeaveTotalHours,a.ALhours,DeptID
FROM TBL_EmployeeInfo a
LEFT JOIN (SELECT EmployeeID,COUNT(1) LeaveCount,SUM(Hours) LeaveTotalHours 
FROM TBL_LeaveInfo WHERE StartTime > @start AND EndTime < @end GROUP BY EmployeeID) b
        ON a.EmployeeID=b.EmployeeID
END*/
EXECUTE SP_ShowLeaveSummary('2010/7/6','2010/7/7');提示信息：
消息 102，级别 15，状态 1，第 78 行
'2010/7/6' 附近有语法错误。
怎么改呢？

Answer 1

ECUTE SP_ShowLeaveSummary '2010/7/6','2010/7/7' 

Answer 2

exec SP_ShowLeaveSummary '2010/7/6','2010/7/7' 

Answer 3

看你少了几个逗号。CREATE PROCEDURE SP_ShowLeaveSummary
@start DATETIME,
@end DATETIME
AS
BEGINSELECT a.EmployeeID,a.EmployeeName,ISNULL(b.LeaveCount,0),LeaveCount,
ISNULL(b.LeaveTotalHours,0),LeaveTotalHours,a.ALhours,DeptID
FROM TBL_EmployeeInfo a
LEFT JOIN (SELECT EmployeeID,COUNT(1) LeaveCount,SUM(Hours) LeaveTotalHours 
FROM TBL_LeaveInfo WHERE StartTime > @start AND EndTime < @end GROUP BY EmployeeID) b
ON a.EmployeeID=b.EmployeeIDEND