摘要:
1.说明:去掉法定节假日(周六,周天)和指定节假日2.创建表脚本:代码 1 CREATE TABLE [dbo].[Holiday] 2 ( 3 ID varchar(36) NOT NULL CONSTRAINT DF_Holiday_ID DEFAULT (newid()), 4 Name varchar(50) NOT NULL, 5 BeginDate date NOT NULL, 6 EndDate date NOT NULL, 7 Flag bit NOT NULL, 8 CONSTRAINT PK_Holiday PRIMARY K... 阅读全文