例如...
ALTER PROCEDURE [dbo].[Reports_Dashboard_Get_Sav]
-- Add the parameters for the stored procedure here
@startDate datetime,
@endDate datetime,
@companyID int=null
set @days=datediff(m,@startdate,@enddate)
if (@days)=0
set @days=1
这不是我的代码,但如果它区分大小写,那么由于startDate/startdate和endDate/enddate变量不匹配,@days将无法正确计算...