SQL Server 获得唯一编号的方法

最新推荐文章于 2024-04-10 08:14:54 发布

weixin_34344677

最新推荐文章于 2024-04-10 08:14:54 发布

阅读量1.2k

点赞数

文章标签：数据库 c/c++

原文链接：https://my.oschina.net/milize/blog/810153

版权

为什么80%的码农都做不了架构师？>>>




USE [数据库名称]

go

CREATE TABLE [dbo].[t_SerialNo](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[name] [nvarchar](20) NOT NULL,
	[currentNo] [bigint] NOT NULL,
	[description] [nvarchar](max) NULL,
 CONSTRAINT [PK_t_SerialNo] PRIMARY KEY CLUSTERED 
(
	[id] 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

insert into [dbo].[t_SerialNo]([name],[currentNo],[description]) values('ComplexTagQuery',1,'复杂标签的查询临时保存编号')

go
-- 蒋振
-- 获得唯一编号
-- 编号存储在t_SerialNo(id,name,currentNo,description)表中
-- e.g.
-- use scada;
-- declare @no bigint
-- exec [dbo].[P_GetSerialNo] 'ComplexTagQuery',@no output
-- print convert(char(20),@no)
alter procedure [dbo].[P_GetSerialNo] 
@name nvarchar(20),
@no bigint out
as
begin
    begin tran
        update t_SerialNo with(rowlock)
        set @no = currentNo + 1, currentNo = currentNo + 1 where name = @name
    commit tran
    return @no
end
go

转载于:https://my.oschina.net/milize/blog/810153