建表sql、生成流水号存储过程

CREATE TABLE [dbo].[BASE_Sequence]( [SeqCode] [varchar](60) NOT NULL, [Desc] [nvarchar](150) NULL, [NowSeqValue] [nchar](10) NULL, [CreateTime] [datetime] NULL, [DateMax] [varchar](10) NULL, [MaxVlaue] [bigint] NULL, [CreateBy] [varchar](50) NULL, [Length] [int] NULL, [Status] [varchar](1) NULL, [InitValue] [varchar](10) NULL, [ResetType] [varchar](50) NULL, [IsRunning] [char](1) NULL, CONSTRAINT [PK_BASE_Sequence] PRIMARY KEY CLUSTERED ( [SeqCode] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO INSERT [dbo].[BASE_Sequence] ([SeqCode], [Desc], [NowSeqValue], [CreateTime], [DateMax], [MaxVlaue], [CreateBy], [Length], [Status], [InitValue], [ResetType], [IsRunning]) VALUES (N'AGV_ActivePushMaterial', N'AGV配送', N'4 ', CAST(N'2023-10-16T15:37:00.000' AS DateTime), N'20231016', 99999999, N'CX', 4, N'1', N'1', N'2', N'1') GO INSERT [dbo].[BASE_Sequence] ([SeqCode], [Desc], [NowSeqValue], [CreateTime], [DateMax], [MaxVlaue], [CreateBy], [Length], [Status], [InitValue], [ResetType], [IsRunning]) VALUES (N'Operation_Siemens_S_700803909', N'工序目录（工序池）Nid流水号', N'575 ', CAST(N'2023-09-06T16:11:27.593' AS DateTime), N'20231218', 999999, N'Liz', 6, N'1', N'1', N'1', N'1') GO INSERT [dbo].[BASE_Sequence] ([SeqCode], [Desc], [NowSeqValue], [CreateTime], [DateMax], [MaxVlaue], [CreateBy], [Length], [Status], [InitValue], [ResetType], [IsRunning]) VALUES (N'PR_ReworkTask', N'返工任务单流水号', N'9 ', CAST(N'2023-10-07T11:19:00.000' AS DateTime), N'20231225', 99999999, N'CX', 4, N'1', N'1', N'4', N'1') GO INSERT [dbo].[BASE_Sequence] ([SeqCode], [Desc], [NowSeqValue], [CreateTime], [DateMax], [MaxVlaue], [CreateBy], [Length], [Status], [InitValue], [ResetType], [IsRunning]) VALUES (N'PR_WorkOrder_WorkingHours', N'工时上报流水号', N'14 ', CAST(N'2023-09-20T11:34:00.000' AS DateTime), N'20231230', 99999999, N'CX', 4, N'1', N'1', N'2', N'1') GO INSERT [dbo].[BASE_Sequence] ([SeqCode], [Desc], [NowSeqValue], [CreateTime], [DateMax], [MaxVlaue], [CreateBy], [Length], [Status], [InitValue], [ResetType], [IsRunning]) VALUES (N'QC_BSInspectItem', N'检验项基础表NId的流水号', N'17435 ', CAST(N'2023-07-19T15:01:10.000' AS DateTime), N'20240103', 99999999, N'Bingo', 4, N'1', N'1', N'2', N'1') GO INSERT [dbo].[BASE_Sequence] ([SeqCode], [Desc], [NowSeqValue], [CreateTime], [DateMax], [MaxVlaue], [CreateBy], [Length], [Status], [InitValue], [ResetType], [IsRunning]) VALUES (N'QC_ExceptionRecord', N'异常提报流水号', N'2 ', CAST(N'2023-09-14T10:34:01.000' AS DateTime), N'20240108', 99999999, N'CX', 4, N'1', N'1', N'2', N'1') GO INSERT [dbo].[BASE_Sequence] ([SeqCode], [Desc], [NowSeqValue], [CreateTime], [DateMax], [MaxVlaue], [CreateBy], [Length], [Status], [InitValue], [ResetType], [IsRunning]) VALUES (N'WH_MaterialPickingRecordDetail', N'拣料打码的标签流水号', N'2 ', CAST(N'2023-08-21T20:14:55.233' AS DateTime), N'20240108', 99999999, N'Liz', 4, N'1', N'1', N'2', N'1') GO INSERT [dbo].[BASE_Sequence] ([SeqCode], [Desc], [NowSeqValue], [CreateTime], [DateMax], [MaxVlaue], [CreateBy], [Length], [Status], [InitValue], [ResetType], [IsRunning]) VALUES (N'WH_RestockOrder', N'补料单流水号', N'2 ', CAST(N'2023-09-26T15:00:00.000' AS DateTime), N'20240105', 99999999, N'CX', 4, N'1', N'1', N'2', N'1') GO INSERT [dbo].[BASE_Sequence] ([SeqCode], [Desc], [NowSeqValue], [CreateTime], [DateMax], [MaxVlaue], [CreateBy], [Length], [Status], [InitValue], [ResetType], [IsRunning]) VALUES (N'WH_ReturnOrder', N'退料单流水号', N'2 ', CAST(N'2023-10-07T11:19:00.000' AS DateTime), N'20240105', 99999999, N'CX', 4, N'1', N'1', N'2', N'1') GO ALTER TABLE [dbo].[BASE_Sequence] ADD CONSTRAINT [DF_BASE_Sequence_NowSeqValue] DEFAULT ((0)) FOR [NowSeqValue] GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'当前序列号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BASE_Sequence', @level2type=N'COLUMN',@level2name=N'NowSeqValue' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'返回的序列号最大值' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BASE_Sequence', @level2type=N'COLUMN',@level2name=N'MaxVlaue' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'返回的序列号长度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BASE_Sequence', @level2type=N'COLUMN',@level2name=N'Length' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'归零方式 @ResetType=1 不归零 2 按日归零 3 按月归零 4按年归零 ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BASE_Sequence', @level2type=N'COLUMN',@level2name=N'ResetType' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'流水号配置表，由存储过程自动生成指定的序号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BASE_Sequence' GO