SQL serial number acquisition code example

This article mainly introduces the sql serial number acquisition code example. The example code is introduced in great detail in the article, which has a certain reference value for everyone's study or work. Friends in need can refer to it.

It is often used to generate order numbers and other serial numbers. SQL Server implements serial numbers as follows:

Table tb_b_Seq (serial number table):

CREATE TABLE tb_b_Seq( 
Year int, -- year Month int, -- month Attr varchar(50), -- attribute Seq int -- serial number)

Get the serial number through the stored procedure:

create Proc GetSeq ( 
@attr varchar(50),
@year int, 
@month int, 
@Return int output ) 
As 
set @Return=(select top 1 Seq from tb_b_Seq where Attr=@attr and MONTH=@month and YEAR=@year) 
if(@Return is null) 
begin 
 set @Return=1 
 insert into FMDS_tb_b_Seq (Attr,Year,Month,Seq) values (@attr,@year,@month,@Return) 
end 
else 
begin 
 set @Return=@Return+1 
 update FMDS_tb_b_Seq set Seq=@Return where Attr=@attr and MONTH=@month and YEAR=@year 
end

test:

declare @ret int 
exec GetSeq 'Contract',2017,10,@ret 
print @ret

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.

You may also be interested in:

Mybatis+mysql uses stored procedures to generate serial number implementation code
oracle (plsql) generates serial number
How to get the query time of MySQL SQL statement in PHP
ThinkPHP framework obtains the last executed SQL statement and variable debugging simple operation example
MySQL example of getting today and yesterday's 0:00 timestamp
mysql gets yesterday's date, today's date, tomorrow's date, and the time of the previous hour and the next hour

<<: jQuery implements shopping cart function

>>: Linux /etc/network/interfaces configuration interface method