[Date5] datetime Null ,

        [Date6] datetime Null ,

        [Date7] datetime Null ,

    [IOTime] datetime Not Null Default(Getdate()),

        [OutPutDate] datetime Null

        CONSTRAINT [PK_WeekProcHistory] PRIMARY KEY  CLUSTERED

        (

                [Id]

        )  ON [PRIMARY]

    ) ON [PRIMARY]

 End

 更新维护表日期数据:
/*

    Procedure Name : 一周交货排程数据更新

    Author Name : lyf

    Date : 01/13/2005

*/

Alter Procedure Pdl_WeekProcDateUpdate As

Declare @num int , @num1 int, @num2 int, @Count int

Declare @Str varchar(4000)

Declare @DateId datetime ,@Date1 datetime , @Date2 datetime ,@Date3 datetime, @Date4 datetime,

@Date5 datetime, @Date6 datetime, @Date7 datetime

Select @DateId = Convert(datetime,

上一页  [1] [2] [3] [4] [5] [6] [7] [8] [9] [10]  ...  下一页 >>