摘要：
--返回第幾周DECLARE @Dt datetimeSELECT @Dt='2008-02-21'SELECT DATEPART( wk, @Dt)SELECT DATEPART( wk, GETDATE())SELECT DATEPART(weekday, GETDATE())SELECT * FROM WorkAttendanceReportSELECT [dbo].[GetWeekName] (WorkAttendanceDatetime) FROM WorkAttendanceReport---WorkAttendanceDatetimedeclare @Date s 阅读全文
