Bruce Xiao 的程序生活

摘要： CREATE PROC pr_GetLastJobDay@Date DATETIMEASdeclare @lastday datetime--得到這個月的最後一天set @lastday=dateadd(dd,-day(@date),dateadd(mm,1,@date))while datename(weekday,@lastday) ='Saturday' or datename(weekda... 阅读全文