Check out this site, it has a neat trick to use identity to generate sequence. It makes use of the fact that identity value is not rolled back after rollback statement.
http://www.mssqltips.com/tip.asp?tip=1293
|
Results 1 to 3 of 3
Threaded View
Tags for this Thread |
|
|
|