本文是一个技巧文章,介绍SQL根据已知的年月,计算该月的天数.
declare @iDays int declare @dt varchar(50) set @dt=@Year+'-'+@Month+'-01'select @iDays=day(dateadd(d,-Day(dateadd(m,1,convert(datetime,@dt))),dateadd(m,1,convert(datetime,@dt))))print @idays