Use functions to generate non-repeated order numbers

The getordernum () function is used to generate the order number.

Order rule, two digits after the current number of years + number of months + date + five digits

The number of new days increases from 00001

 

Source code:

Create Table [DBO]. [ordertest] (
[Orderid] [varchar] (50) null,
[Ordername] [varchar] (50) null
) On [primary]

Create Function [DBO]. [getordernum] ()
Returns varchar (50)
As
Begin
Declare @ code varchar (50)
-- Right (convert (varchar (100), getdate (), 112), 6) get time 120105

Select @ code = right (convert (varchar (100), getdate (), 112), 6) + right ('20140901' + Cast (
Isnull (max (right (orderid, 5), 0) + 1 as varchar), 5)
From ordertest with (xlock, paglock) Where left (orderid, 6) = right (convert (varchar (100), getdate (), 112), 6) -- Create Table-level locks

Return @ code
End
Go

Test example:

Insert into ordertest values (DBO. getordernum (), 'clc2008 ');