tb_plant_calendar.sql

工厂采购系统,DELPHI+SQL SERVER,三层技术

if object_id('dbo.Plant_Calendar') is not null
drop table Plant_Calendar
go

create table Plant_Calendar
(
 FDate datetime  not null default getdate(),
 FYear int	 not null,
 FMonth int 	 not null,
 FDay    int     not null,
 Holiday_Flag   bit not null,
 Remark         varchar(120) null
)

declare
 @i datetime 
select @i = getdate();
while datepart(yy,@i)<=2008
begin
	select @i=cast(convert(varchar(50),@i,111) as Datetime)
	insert into Plant_Calendar values(@i,datepart(yy,@i),datepart(mm,@i),datepart(dd,@i),0,'')
	select @i = @i+1
end
go

select * From Plant_Calendar