复制alter function fn_getDayByYearMonth(@year int,使用数获数@month int) returns int begin declare @date datetime declare @day int if(@month<>12) begin set @month = @month + 1 set @date = cast(cast(@year as varchar)+-+cast(@month as varchar)+-1 as datetime) end if(@month=12) begin set @date = cast(cast(@year as varchar)+-+cast(@month as varchar)+-31 as datetime) end set @dayday = day(@date-1) return @day end 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.