小case,订单表设计,您们如何设计的 rt 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 订单表 id ... 来处理比较比好管理 if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[订货单]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[订货单] GO CREATE TABLE [dbo].[订货单] ( [单据编号] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [商品编号] [int] NOT NULL , [批号] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [有效期] [datetime] NULL , [单价] [real] NULL , [数量] [real] NULL , [税率] [real] NULL , [序号] [int] NULL , [原因] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [父编号] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [进货价] [real] NULL , [加权进价] [real] NULL , [批发价] [real] NULL , [零售价] [real] NULL , [折扣] [real] NULL , [到货数量] [real] NULL , [选定的供货商] [int] NULL , [采购员备注] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL , [经理批示] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL , [供货商备注] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL , [是否订货] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[订货单ID]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[订货单ID] GO CREATE TABLE [dbo].[订货单ID] ( [单据编号] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [发货方号] [int] NULL , [收货方号] [int] NULL , [日期] [datetime] NULL , [批比日期] [datetime] NULL , [交易金额] AS ([dbo].[fJEDH]([单据编号])) , [制表] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [审核] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [仓库签名] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [业务签名] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [财务签名] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [质量签名] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [经理签名] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [分店签名] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [备注] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [创建日期] [datetime] NULL , [签名集合] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [采购签名] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [最后修改日期] [datetime] NULL , [采购员] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [仓库签名时间] [datetime] NULL , [创建人] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO 供参考 订单表和物品表的关系是怎样的?如主外键关系 如何用sysbas设计 关于周次的头痛的问题 SQL数据分组求和问题 一张表向另一张表插入数据问题 这个语句怎么写啊,救命啊。 请问这句SQL语句是什么意思?? select时为什么会报连接占线错误 SQL 查询的时候加上一个条件 如何取得最小值! 这个问题怎么样? 好急呀!如何将Excel文件格式的数据转到Sql Server中去呀!!! 请大家看个错误,怎么解决???????在线等.......... SQL判断返回结果
订单表
id ...
来处理比较比好管理
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[订货单]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[订货单]
GO CREATE TABLE [dbo].[订货单] (
[单据编号] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[商品编号] [int] NOT NULL ,
[批号] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[有效期] [datetime] NULL ,
[单价] [real] NULL ,
[数量] [real] NULL ,
[税率] [real] NULL ,
[序号] [int] NULL ,
[原因] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[父编号] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[进货价] [real] NULL ,
[加权进价] [real] NULL ,
[批发价] [real] NULL ,
[零售价] [real] NULL ,
[折扣] [real] NULL ,
[到货数量] [real] NULL ,
[选定的供货商] [int] NULL ,
[采购员备注] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[经理批示] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[供货商备注] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
[是否订货] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[订货单ID]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[订货单ID]
GO CREATE TABLE [dbo].[订货单ID] (
[单据编号] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[发货方号] [int] NULL ,
[收货方号] [int] NULL ,
[日期] [datetime] NULL ,
[批比日期] [datetime] NULL ,
[交易金额] AS ([dbo].[fJEDH]([单据编号])) ,
[制表] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[审核] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[仓库签名] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[业务签名] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[财务签名] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[质量签名] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[经理签名] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[分店签名] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[备注] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[创建日期] [datetime] NULL ,
[签名集合] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[采购签名] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[最后修改日期] [datetime] NULL ,
[采购员] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[仓库签名时间] [datetime] NULL ,
[创建人] [char] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO 供参考
如何用sysbas设计