mile

摘要： 一、sql1.排除工作日函数CREATE FUNCTION [dbo].[getWorkDays] (@begin_date datetime,@end_date datetime)RETURNS intASBEGINDECLARE @workdays intDECLARE @begin_day_of_work intDECLARE @totalDays intSET @workdays = 0SET @totalDays = 0SET @begin_day_of_work = datepart(dw,@begin_date)IF (@begin_day_of_work>1 and @b 阅读全文