Click here to Skip to main content
       

Database

 
GeneralRe: how to comlex databinding with access database PinmemberAchilles8430-Jan-13 20:49 
GeneralRe: how to comlex databinding with access database PinmemberMycroft Holmes30-Jan-13 21:06 
GeneralRe: how to comlex databinding with access database PinmemberAchilles841-Feb-13 0:25 
QuestionEnd Case in a Variable Pinmemberberba30-Jan-13 8:47 
AnswerRe: End Case in a Variable PinmemberMycroft Holmes30-Jan-13 11:46 
GeneralRe: End Case in a Variable Pinmemberberba30-Jan-13 18:02 
GeneralRe: End Case in a Variable PinmemberMycroft Holmes30-Jan-13 20:57 
QuestionWhat happens with auto-incremented value on rollback? Pinmemberpiticcotoc29-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? PinmemberJörgen Andersson30-Jan-13 1:04 
GeneralRe: What happens with auto-incremented value on rollback? Pinmemberpiticcotoc30-Jan-13 3:02 
GeneralRe: What happens with auto-incremented value on rollback? Pinmembermark merrens30-Jan-13 5:33 
GeneralRe: What happens with auto-incremented value on rollback? Pinmemberpiticcotoc30-Jan-13 5:43 
GeneralRe: What happens with auto-incremented value on rollback? PinmemberSimon_Whale30-Jan-13 5:49 
GeneralRe: What happens with auto-incremented value on rollback? Pinmembermark merrens30-Jan-13 5:55 
GeneralRe: What happens with auto-incremented value on rollback? Pinmemberpiticcotoc30-Jan-13 21:43 
AnswerRe: What happens with auto-incremented value on rollback? PinmvpEddy Vluggen30-Jan-13 22:50 
GeneralRe: What happens with auto-incremented value on rollback? Pinmemberpiticcotoc30-Jan-13 23:17 
NewsRe: What happens with auto-incremented value on rollback? PinmvpEddy Vluggen31-Jan-13 3:16 
GeneralRe: What happens with auto-incremented value on rollback? Pinmembermark merrens31-Jan-13 5:18 
GeneralRe: What happens with auto-incremented value on rollback? PinmemberPIEBALDconsult30-Jan-13 10:29 
GeneralRe: What happens with auto-incremented value on rollback? Pinmemberpiticcotoc30-Jan-13 22:09 
GeneralRe: What happens with auto-incremented value on rollback? Pinmemberpmpdesign30-Jan-13 19:46 
GeneralRe: What happens with auto-incremented value on rollback? PinmemberJörgen Andersson30-Jan-13 7:37 
AnswerRe: What happens with auto-incremented value on rollback? PinmemberShameel30-Jan-13 3:15 
GeneralRe: What happens with auto-incremented value on rollback? Pinmemberpiticcotoc30-Jan-13 5:45 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    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
Web04 | 2.8.140916.1 | Last Updated 18 Sep 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid