Click here to Skip to main content
15,903,854 members
Home / Discussions / Database
   

Database

 
AnswerRe: Update Database for C# application Pin
PDTUM21-Feb-14 5:50
PDTUM21-Feb-14 5:50 
GeneralRe: Update Database for C# application Pin
Nicholas Swandel21-Feb-14 6:20
Nicholas Swandel21-Feb-14 6:20 
Questionbegin tran in sql server 2008 Pin
vkEE19-Feb-14 5:22
vkEE19-Feb-14 5:22 
AnswerRe: begin tran in sql server 2008 Pin
GuyThiebaut19-Feb-14 6:02
professionalGuyThiebaut19-Feb-14 6:02 
GeneralRe: begin tran in sql server 2008 Pin
vkEE19-Feb-14 6:13
vkEE19-Feb-14 6:13 
GeneralRe: begin tran in sql server 2008 Pin
GuyThiebaut19-Feb-14 6:27
professionalGuyThiebaut19-Feb-14 6:27 
GeneralRe: begin tran in sql server 2008 Pin
vkEE19-Feb-14 6:43
vkEE19-Feb-14 6:43 
GeneralRe: begin tran in sql server 2008 Pin
GuyThiebaut19-Feb-14 7:32
professionalGuyThiebaut19-Feb-14 7:32 
Glad it helps.

For what is't worth, and I am sure others will disagree with me - don't use the transaction begin, commit rollback system for admin work on the database.
Write a select query to test the update, create a backup table of the rows you are about to update, run the update and check the changes.
If there is a problem restore the rows using the backup table you created.
Using the transaction system to get you out of trouble is bad practise and will one day ;and you in trouble.

If you use your current system you are going to lock the rows and there is a real danger that you will forget the commit or you will accidentally run a commit when you did not mean to.

How do I know this?

I used to do what you are now doing, years ago, and through a considerable experience of embarrassment learnt to use the method I illustrate above.


In summary:
Don't run an update without testing it and knowing what the results will be.
Take a backup, of the rows being updated, to restore the rows in case something goes wrong, which it won't as you fully tested the update with a select statement first.
“That which can be asserted without evidence, can be dismissed without evidence.”

― Christopher Hitchens

GeneralRe: begin tran in sql server 2008 Pin
vkEE19-Feb-14 8:25
vkEE19-Feb-14 8:25 
GeneralRe: begin tran in sql server 2008 Pin
GuyThiebaut19-Feb-14 8:43
professionalGuyThiebaut19-Feb-14 8:43 
GeneralRe: begin tran in sql server 2008 Pin
Eddy Vluggen19-Feb-14 8:52
professionalEddy Vluggen19-Feb-14 8:52 
GeneralRe: begin tran in sql server 2008 Pin
Ananth A21-Feb-14 0:43
Ananth A21-Feb-14 0:43 
GeneralRe: begin tran in sql server 2008 Pin
GuyThiebaut21-Feb-14 0:56
professionalGuyThiebaut21-Feb-14 0:56 
GeneralRe: begin tran in sql server 2008 Pin
Eddy Vluggen19-Feb-14 8:25
professionalEddy Vluggen19-Feb-14 8:25 
GeneralRe: begin tran in sql server 2008 Pin
vkEE19-Feb-14 8:30
vkEE19-Feb-14 8:30 
GeneralRe: begin tran in sql server 2008 Pin
GuyThiebaut19-Feb-14 8:47
professionalGuyThiebaut19-Feb-14 8:47 
GeneralRe: begin tran in sql server 2008 Pin
vkEE19-Feb-14 8:59
vkEE19-Feb-14 8:59 
GeneralRe: begin tran in sql server 2008 Pin
GuyThiebaut19-Feb-14 10:26
professionalGuyThiebaut19-Feb-14 10:26 
GeneralRe: begin tran in sql server 2008 Pin
Eddy Vluggen19-Feb-14 8:59
professionalEddy Vluggen19-Feb-14 8:59 
AnswerRe: begin tran in sql server 2008 Pin
Corporal Agarn19-Feb-14 8:22
professionalCorporal Agarn19-Feb-14 8:22 
QuestionSQL Server and IDENTITY Pin
gmhanna18-Feb-14 8:33
gmhanna18-Feb-14 8:33 
AnswerRe: SQL Server and IDENTITY Pin
David Mujica18-Feb-14 8:43
David Mujica18-Feb-14 8:43 
GeneralRe: SQL Server and IDENTITY Pin
gmhanna18-Feb-14 9:32
gmhanna18-Feb-14 9:32 
GeneralRe: SQL Server and IDENTITY Pin
Richard Deeming18-Feb-14 11:04
mveRichard Deeming18-Feb-14 11:04 
JokeRe: SQL Server and IDENTITY Pin
ZurdoDev18-Feb-14 15:31
professionalZurdoDev18-Feb-14 15:31 

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.