Click here to Skip to main content
14,211,795 members
   

Database

 
GeneralRe: how to comlex databinding with access database Pin
Achilles8430-Jan-13 20:49
memberAchilles8430-Jan-13 20:49 
GeneralRe: how to comlex databinding with access database Pin
Mycroft Holmes30-Jan-13 21:06
memberMycroft Holmes30-Jan-13 21:06 
GeneralRe: how to comlex databinding with access database Pin
Achilles841-Feb-13 0:25
memberAchilles841-Feb-13 0:25 
QuestionEnd Case in a Variable Pin
berba30-Jan-13 8:47
memberberba30-Jan-13 8:47 
AnswerRe: End Case in a Variable Pin
Mycroft Holmes30-Jan-13 11:46
memberMycroft Holmes30-Jan-13 11:46 
GeneralRe: End Case in a Variable Pin
berba30-Jan-13 18:02
memberberba30-Jan-13 18:02 
GeneralRe: End Case in a Variable Pin
Mycroft Holmes30-Jan-13 20:57
memberMycroft Holmes30-Jan-13 20:57 
QuestionWhat happens with auto-incremented value on rollback? Pin
piticcotoc29-Jan-13 23:27
memberpiticcotoc29-Jan-13 23:27 
I'm trying to find the answer to this question.

Let's say you have a MSSQL database which has a table with an auto-incremented field. If I have a Sql transaction sent to the server (through code) that does an insert into that table and the transaction fails (and does a rollback) will the current ID be lost or not?
When does it generate the new ID? At transaction start or finish?

Ex: table1 has column ID as auto-increment. the current ID is 100. If I send a transaction with an insert does is reserve the ID 101 and loose it if the transaction fails with rollback, meaning next ID would be 102? Or will it take the ID 101 only if the transaction commits successfully?

thanks
AnswerRe: What happens with auto-incremented value on rollback? Pin
Jörgen Andersson30-Jan-13 1:04
protectorJörgen Andersson30-Jan-13 1:04 
GeneralRe: What happens with auto-incremented value on rollback? Pin
piticcotoc30-Jan-13 3:02
memberpiticcotoc30-Jan-13 3:02 
GeneralRe: What happens with auto-incremented value on rollback? Pin
R. Giskard Reventlov30-Jan-13 5:33
professionalR. Giskard Reventlov30-Jan-13 5:33 
GeneralRe: What happens with auto-incremented value on rollback? Pin
piticcotoc30-Jan-13 5:43
memberpiticcotoc30-Jan-13 5:43 
GeneralRe: What happens with auto-incremented value on rollback? Pin
Simon_Whale30-Jan-13 5:49
professionalSimon_Whale30-Jan-13 5:49 
GeneralRe: What happens with auto-incremented value on rollback? Pin
R. Giskard Reventlov30-Jan-13 5:55
professionalR. Giskard Reventlov30-Jan-13 5:55 
GeneralRe: What happens with auto-incremented value on rollback? Pin
piticcotoc30-Jan-13 21:43
memberpiticcotoc30-Jan-13 21:43 
AnswerRe: What happens with auto-incremented value on rollback? Pin
Eddy Vluggen30-Jan-13 22:50
mveEddy Vluggen30-Jan-13 22:50 
GeneralRe: What happens with auto-incremented value on rollback? Pin
piticcotoc30-Jan-13 23:17
memberpiticcotoc30-Jan-13 23:17 
NewsRe: What happens with auto-incremented value on rollback? Pin
Eddy Vluggen31-Jan-13 3:16
mveEddy Vluggen31-Jan-13 3:16 
GeneralRe: What happens with auto-incremented value on rollback? Pin
R. Giskard Reventlov31-Jan-13 5:18
professionalR. Giskard Reventlov31-Jan-13 5:18 
GeneralRe: What happens with auto-incremented value on rollback? Pin
PIEBALDconsult30-Jan-13 10:29
protectorPIEBALDconsult30-Jan-13 10:29 
GeneralRe: What happens with auto-incremented value on rollback? Pin
piticcotoc30-Jan-13 22:09
memberpiticcotoc30-Jan-13 22:09 
GeneralRe: What happens with auto-incremented value on rollback? Pin
pmpdesign30-Jan-13 19:46
memberpmpdesign30-Jan-13 19:46 
GeneralRe: What happens with auto-incremented value on rollback? Pin
Jörgen Andersson30-Jan-13 7:37
protectorJörgen Andersson30-Jan-13 7:37 
AnswerRe: What happens with auto-incremented value on rollback? Pin
Shameel30-Jan-13 3:15
professionalShameel30-Jan-13 3:15 
GeneralRe: What happens with auto-incremented value on rollback? Pin
piticcotoc30-Jan-13 5:45
memberpiticcotoc30-Jan-13 5:45 

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 | Cookies | Terms of Service
Web01 | 2.8.190619.2 | Last Updated 10 Jun 2019
Copyright © CodeProject, 1999-2019
All Rights Reserved.
Layout: fixed | fluid