学习程版网络编号--断号不能补回求大神指点 - 专家坐堂 - Foxtable(狐表) - 新一代数据库软件，完美融合Access、Foxpro、Excel、vb.net之优势，人人都能掌握的快速软件开发工具!

附表结构:

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]

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]

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]

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]

主题：学习程版网络编号--断号不能补回 求大神指点

主题：学习程版网络编号--断号不能补回求大神指点