CREATE TABLE [dbo].[SeqT_0101001](
[id] [int] IDENTITY(1,1) NOT NULL,
[SeqVal] [nchar](10) NOT NULL
) ON [PRIMARY]
CREATE procedure [dbo].[P_GetNewSeqVal_SeqT_0101001]
as
begin
-- 声明新Sequence值变量
declare @NewSeqValue int
-- 设置插入、删除操作后的条数显示取消
set NOCOUNT ON
-- 插入新值到SeqT_0101001表
insert into SeqT_0101001 (SeqVal) values ('a')
-- 设置新Sequence值为插入到SeqT_0101001表的标识列内的最后一个标识值
set @NewSeqValue = scope_identity()
-- 删除SeqT_0101001表(不显示被锁行)
delete from SeqT_0101001 WITH (READPAST)
-- 返回新Sequence值
return @NewSeqValue
end