bundle.txt

来自「二次开发模块 一、条形码的批量生成」· 文本 代码 · 共 14 行

CREATE TABLE [Bundle_^cYearMonth] (
	[BDCode] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[cYearMonth] [varchar] (6) COLLATE Chinese_PRC_CI_AS NOT NULL 
        CHECK ([cYearMonth]='^cYearMonth'),
	[dDate] [datetime] NULL ,
	[cMaker] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[cBarCode] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	CONSTRAINT [PK_Bundle_^cYearMonth] PRIMARY KEY  CLUSTERED 
	(
		[BDCode],
                [cBarCode],
		[cYearMonth]
	)  ON [PRIMARY] 
) ON [PRIMARY]