- Foxtable(狐表) (http://foxtable.net/bbs/index.asp)
-- 专家坐堂 (http://foxtable.net/bbs/list.asp?boardid=2)
---- 学习程版网络编号--断号不能补回 求大神指点 (http://foxtable.net/bbs/dispbbs.asp?boardid=2&id=46850)
-- 发布时间：2014/2/28 12:48:00
-- 学习程版网络编号--断号不能补回 求大神指点
学习程版网络编号--断号不能补回 求大神指点
| 下载信息 [文件大小： 下载次数： ] | |
 点击浏览该文件:学习程版网络编号--断号不能补回.rar |
-- 发布时间：2014/2/28 12:51:00
--
附表结构:
CREATE TABLE [dbo].[订单](
[_Identify] [bigint] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[单位] [nvarchar](50) NULL,
[订单ID] [varchar](30) NULL,
[订单日期] [smalldatetime] NULL,
[年份] [smallint] NULL,
[月份] [tinyint] NULL,
[_Locked] [bit] NULL,
CONSTRAINT [PK_订单] PRIMARY KEY CLUSTERED
(
[_Identify] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[出库](
[_Identify] [bigint] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[单位] [nvarchar](50) NULL,
[出库单ID] [varchar](30) NULL,
[出库日期] [smalldatetime] NULL,
[年份] [smallint] NULL,
[月份] [tinyint] NULL,
[_Locked] [bit] NULL,
CONSTRAINT [PK_出库] PRIMARY KEY CLUSTERED
(
[_Identify] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[编号](
[_identify] [int] IDENTITY(1,1) NOT NULL,
[前缀] [nchar](25) NULL,
[顺序号] [int] NULL,
[表名] [varchar](150) NULL,
[已用标识] [bit] NULL,
[日期] [datetime] NULL,
CONSTRAINT [PK_编号] PRIMARY KEY CLUSTERED
(
[_identify] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[sys_系统设置](
[_Identify] [bigint] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[设置名称] [varchar](150) NULL,
[设置值] [varchar](50) NULL,
[_Locked] [bit] NULL,
CONSTRAINT [PK_系统设置] PRIMARY KEY CLUSTERED
(
[_Identify] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
-- 发布时间：2014/2/28 20:58:00
--
请程支个招！
-- 发布时间：2014/3/1 9:25:00
--
断号应该允许存在，不需要补。
-- 发布时间：2014/3/1 10:45:00
--
号码 应该同身份证唯一的 断的号码不要补为妙
-- 发布时间：2014/3/1 11:08:00
--
还是不补的好。
-- 发布时间：2014/3/1 11:18:00
--
主要是需求不合理,强行这样做会带出更多问题. 然后处理那些问题会带出更多更多的问题.
-- 发布时间：2014/3/1 11:55:00
--
需求是五花八门的，既然Lz有此需要，为何大师不指导一下呢