在T-SQL 确定日期是否是工作日或周末 mssql

create function fn_IsWeekDay (    @date datetime )returns bit as begin     declare @dtfirst int    declare @dtweek int     declare @iswkday bit     set @dtfirst = @@datefirst - 1    set @dtweek = datepart(weekday, @date) - 1    if (@dtfirst + @dtweek) % 7 not in (5, 6)        set @iswkday = 1 --business day    else        set @iswkday = 0 --weekend    return @iswkdayend

 

Short and sweet. Now you can simply do this:

 

if dbo.fn_IsWeekDay(@date) = 1 begin     --do some magic here ;-)end --or select a.SomeFieldsForCalculation from table a where dbo.fn_IsWeekDay(a.SomeDateField) = 1