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

Posted on    February-01-2011 12:00 AM

 MSSQL Server MSSQL Server 
 1 Answer(s)
  1841  View(s)
Rate this:

Vikas Giri
Vikas Giri

Total Post:33

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