【SQL开源代码栏目提醒】:网学会员SQL开源代码为您提供SaleChance.sql参考,解决您在SaleChance.sql学习中工作中的难题,参考学习。
USE Mis
GO
CREATE TABLE [SaleChance] (
[Id] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[CustId] [int] NULL ,
[CtId] [int] NULL ,
[ProName] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[PTypeId] [int] NULL ,
[EmpId] [int] NULL ,
[SignDate] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[SignSum] [float] NULL ,
[PPercent] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[Status] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[Detail] [varchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
CONSTRAINT [PK_SaleChance] PRIMARY KEY CLUSTERED
(
[Id]
) ON [PRIMARY]
) ON [PRIMARY]
GO