Click here to Skip to main content
12,248,742 members (36,488 online)
   

Database

 
GeneralRe: End Case in a Variable Pin
berba30-Jan-13 19:02
memberberba30-Jan-13 19:02 
GeneralRe: End Case in a Variable Pin
Mycroft Holmes30-Jan-13 21:57
memberMycroft Holmes30-Jan-13 21:57 
QuestionWhat happens with auto-incremented value on rollback? Pin
piticcotoc30-Jan-13 0:27
memberpiticcotoc30-Jan-13 0:27 
AnswerRe: What happens with auto-incremented value on rollback? Pin
Jörgen Andersson30-Jan-13 2:04
memberJörgen Andersson30-Jan-13 2:04 
GeneralRe: What happens with auto-incremented value on rollback? Pin
piticcotoc30-Jan-13 4:02
memberpiticcotoc30-Jan-13 4:02 
GeneralRe: What happens with auto-incremented value on rollback? Pin
mark merrens30-Jan-13 6:33
membermark merrens30-Jan-13 6:33 
GeneralRe: What happens with auto-incremented value on rollback? Pin
piticcotoc30-Jan-13 6:43
memberpiticcotoc30-Jan-13 6:43 
GeneralRe: What happens with auto-incremented value on rollback? Pin
Simon_Whale30-Jan-13 6:49
memberSimon_Whale30-Jan-13 6:49 
Maybe we can chalk this down to a lost in translation but what Jorgen said is correct.

Identity columns allow you to assign a unqiue value to each row. It doesn't get reset to the previous value if you rollback the transaction.


If you require no gaps in your keys then you will need to think of a different approach.
Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch

GeneralRe: What happens with auto-incremented value on rollback? Pin
mark merrens30-Jan-13 6:55
membermark merrens30-Jan-13 6:55 
GeneralRe: What happens with auto-incremented value on rollback? Pin
piticcotoc30-Jan-13 22:43
memberpiticcotoc30-Jan-13 22:43 
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 
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 

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.160426.1 | Last Updated 3 May 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid