【SQL开源代码栏目提醒】:网学会员,鉴于大家对SQL开源代码十分关注,论文会员在此为大家搜集整理了“PurchaseOrder.sql”一文,供大家参考学习!
USE Mis
GO
CREATE TABLE [dbo].[PurchaseOrder] (
[PurId] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[EmpId] [int] NULL ,
[Status] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[GetDate] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[ProSum] [decimal](9, 2) NULL ,
[OtherCost] [decimal](9, 0) NULL ,
[Memo] [varchar] (2000) COLLATE Chinese_PRC_CI_AS NULL ,
[CreateDate] [datetime] NULL ,
[Poster] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO