Click here to Skip to main content
12,821,315 members (30,558 online)
   

Database

 
AnswerRe: What happens with auto-incremented value on rollback? Pin
Eddy Vluggen30-Jan-13 23:50
mvpEddy Vluggen30-Jan-13 23:50 
GeneralRe: What happens with auto-incremented value on rollback? Pin
piticcotoc31-Jan-13 0:17
memberpiticcotoc31-Jan-13 0:17 
NewsRe: What happens with auto-incremented value on rollback? Pin
Eddy Vluggen31-Jan-13 4:16
mvpEddy Vluggen31-Jan-13 4:16 
GeneralRe: What happens with auto-incremented value on rollback? Pin
mark merrens31-Jan-13 6:18
membermark merrens31-Jan-13 6:18 
GeneralRe: What happens with auto-incremented value on rollback? Pin
PIEBALDconsult30-Jan-13 11:29
memberPIEBALDconsult30-Jan-13 11:29 
GeneralRe: What happens with auto-incremented value on rollback? Pin
piticcotoc30-Jan-13 23:09
memberpiticcotoc30-Jan-13 23:09 
GeneralRe: What happens with auto-incremented value on rollback? Pin
pmpdesign30-Jan-13 20:46
memberpmpdesign30-Jan-13 20:46 
GeneralRe: What happens with auto-incremented value on rollback? Pin
Jörgen Andersson30-Jan-13 8:37
memberJörgen Andersson30-Jan-13 8:37 
I do know, and I did tell you to rethink your design.

If you had used Oracle it would have been much worse, Oracle cache the sequences, so if you restart the server you can get a gap of twenty numbers. and if you have a cluster server they won't even be in order.
(<for the nitpicks> I know it's a setting, but if you want higher performance you don't change it</for the nitpicks>)
People say nothing is impossible, but I do nothing every day.

AnswerRe: What happens with auto-incremented value on rollback? Pin
Shameel30-Jan-13 4:15
memberShameel30-Jan-13 4:15 
GeneralRe: What happens with auto-incremented value on rollback? Pin
piticcotoc30-Jan-13 6:45
memberpiticcotoc30-Jan-13 6:45 
AnswerRe: What happens with auto-incremented value on rollback? Pin
i.j.russell30-Jan-13 5:37
memberi.j.russell30-Jan-13 5:37 
GeneralRe: What happens with auto-incremented value on rollback? Pin
piticcotoc30-Jan-13 6:41
memberpiticcotoc30-Jan-13 6:41 
AnswerRe: What happens with auto-incremented value on rollback? Pin
Mycroft Holmes30-Jan-13 12:44
memberMycroft Holmes30-Jan-13 12:44 
GeneralRe: What happens with auto-incremented value on rollback? Pin
PIEBALDconsult31-Jan-13 4:40
memberPIEBALDconsult31-Jan-13 4:40 
AnswerRe: What happens with auto-incremented value on rollback? Pin
gvprabu21-Feb-13 0:02
membergvprabu21-Feb-13 0:02 
QuestionBook recommendation for learning SQL Pin
Lloyd Atkinson29-Jan-13 19:33
memberLloyd Atkinson29-Jan-13 19:33 
AnswerRe: Book recommendation for learning SQL Pin
Jörgen Andersson30-Jan-13 1:52
memberJörgen Andersson30-Jan-13 1:52 
AnswerRe: Book recommendation for learning SQL Pin
i.j.russell30-Jan-13 5:34
memberi.j.russell30-Jan-13 5:34 
AnswerRe: Book recommendation for learning SQL Pin
Simon_Whale30-Jan-13 6:46
memberSimon_Whale30-Jan-13 6:46 
AnswerRe: Book recommendation for learning SQL Pin
djj5530-Jan-13 7:33
memberdjj5530-Jan-13 7:33 
AnswerRe: Book recommendation for learning SQL Pin
gvprabu21-Feb-13 0:09
membergvprabu21-Feb-13 0:09 
QuestionCan we delete old records from aspstatetempsessions table? Pin
manikantaer29-Jan-13 18:43
membermanikantaer29-Jan-13 18:43 
AnswerRe: Can we delete old records from aspstatetempsessions table? Pin
thatraja4-Oct-13 21:46
mvpthatraja4-Oct-13 21:46 
Questioncontrol AVG cost and close stock Pin
kornkimhour29-Jan-13 16:13
memberkornkimhour29-Jan-13 16:13 
AnswerRe: control AVG cost and close stock Pin
thatraja4-Oct-13 21:50
mvpthatraja4-Oct-13 21:50 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web02 | 2.8.170308.1 | Last Updated 24 Mar 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid