|
|
|
|
| Re: some useful tip about sequences [message #246940 is a reply to message #246896] |
Fri, 22 June 2007 10:02  |
majstoru
Messages: 68
Registered: October 2006
Location: Serbia
|
Member |
|
|
Here is few samples:
1. At the end of year DB is empty some tables and to set their qequences to 0.
2. When I bring new records of table reports to setup max(id) as next sequence value.
3. When import data from previous system where id (which is generated by sequencers) is fix and I input that filed too, to set up max(id)+1 as next value.
...
Thanks Michael!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
