Why to use SQL Sequence and its drawbacks
| In SQL Sequences are used for creating sequence numbers without any overhead of locking but one drawback is that when any of transaction is rolled back the sequence number is lost. | |
Sql Server Interview Questions