MS SQL 取得不重复数

 

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