[Qnty6] int Null Default(0),

        [Qnty7] int Null Default(0)--,

--     [WeekDate] datetime

        CONSTRAINT [PK_WeekProcedure] PRIMARY KEY  CLUSTERED

        (

                [Id]

        )  ON [PRIMARY]

    ) ON [PRIMARY]

End

 -----------------创建日期表--------------------

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

drop table Pdl_WeekProcedureDate

GO

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

 BEGIN

        Create Table Pdl_WeekProcedureDate (

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

        [DateId] datetime Not Null ,

        [Date1] datetime Null ,

        [Date2] datetime Null ,

        [Date3] datetime Null ,

        [Date4] datetime Null ,

        [Date5] datetime Null ,

        [Date6] datetime Null ,

        [Date7] datetime Null

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