Home > DeveloperSection > Interviews > Why to use SQL Sequence and its drawbacks ?

Posted on    February-01-2011 12:00 AM

 MSSQL Server MSSQL Server 
Ratings:
 1 Answer(s)
  1646  View(s)
Rate this:

Vikas Giri
Vikas Giri

Total Post:33

Points:165
Posted on    February-01-2011 1:00 AM

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.

Don't want to miss updates? Please click the below button!

Follow MindStick