(

                [Id]

        )  ON [PRIMARY]

    ) ON [PRIMARY]

 End

----------- 创建历一周交货排程史表 ----------------------------------

if exists (select * from dbo.sysobjects where id = object_id(N''''[dbo].[Pdl_WeekProcHistory]'''') and OBJECTPROPERTY(id, N''''IsUserTable'''') = 1)

drop table Pdl_WeekProcHistory

GO

 if not exists (select * from dbo.sysobjects where id = object_id(N''''[dbo].[Pdl_WeekProcHistory]'''') and OBJECTPROPERTY(id, N''''IsUserTable'''') = 1)

 BEGIN

        Create Table Pdl_WeekProcHistory (

        [Id] int Identity(1,1) Not Null,

        [DateId] datetime Not Null ,

    [Partnum] varchar(20) Null ,

        [Revision] varchar(5) Null DEFAULT(''''0''''),

        [Qnty1] int Null Default(0),

        [Qnty2] int Null Default(0),

        [Qnty3] int Null Default(0),

        [Qnty4] int Null Default(0),

        [Qnty5] int Null Default(0),

        [Qnty6] int Null Default(0),

        [Qnty7] int Null Default(0),

        [Date1] datetime Null ,

        [Date2] datetime Null ,

        [Date3] datetime Null ,

    &nb

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