Such as 2017040100001, eight date + 5 digit, the sequence of 0401 day two to 00999, the second day to sequence starting from 2017040200001, how to create the sequence

CodePudding user response:

Maxvalue options, see if I can meet your needs;

CodePudding user response:

reference 1st floor wmxcn2000 response:

maxvalue options, see if I can meet your needs;

can't,,, maxvalue not only set a maximum, what I need is based on date to five digits after cycle

CodePudding user response:

0401 day sequence ranked 00999

If the day in 0401, to 1000, starting from 1, too? Or the third row, 1000100, 1100, 2100, the second day to return 1?

CodePudding user response:

reference wmxcn2000 reply: 3/f

0401 day sequence ranked 00999

If the day in 0401, to 1000, starting from 1, too? Or the third row, 1000100, 1100, 2100, the second day to return 1?

in guarantee under the premise of not more than 9999 in one day

CodePudding user response:

Sequences do not have any practical significance, it is necessary? And other fields to achieve good
Increase the difficulty of control from afar

CodePudding user response:

The next day after drop sequence recreate?

CodePudding user response:

Regularity of initialization, then don't use sequence, a maximum + 1, a good control

CodePudding user response:

refer to 6th floor u012557814 response:

to recreate after the second day drop sequence?

Good idea, is the DDL operation causes dependent objects;

CodePudding user response:

https://bbs.csdn.net/topics/390919409, you see a reference to write this post said the technical implementation of like this with you about the same I just glanced at the next also find the hope to help you

CodePudding user response:

Write a regular task, before going to work run update seq

CodePudding user response:

In addition to build a field record is not good