.NET Answers

Archive for April 15th, 2009

Ruth ask,

How do I do transaction tracking within a stored procedure?

Hopefully, if you’ve been programming for any length of time against databases, you know that if you are updating multiple records in a database, you need to supply some sort of transaction tracking so that it either all works or all fails.

You do know that, right?

Well, maybe we should cover that in a future post.

But today, what happens if you have a stored procedure that updates multiple records in the database?  I can’t depend on the programmer to implement transaction tracking because all he sees is one call.  How is he supposed to know that it’s updating multiple records and should turn on transaction tracking in his code?

Read the rest of this entry »

Other Related Items:

Quicken 2010 The Official Guide (Quicken Press)The Only Official Guide to the #1 Personal Finance Software

Manage your finances and assets with ease! Quicken 2010: The Official Guide is p... Read More >

Learning PHP, MySQL, and JavaScript: A Step-By-Step Guide to Creating Dynamic Websites (Animal Guide)If you know HTML, this guide will have you building interactive websites quickly. You'll learn how to create responsive, data-driven websites with PHP... Read More >

Mouse Cube - The Gentle Mouse Trap - 4 x 4 Pack4 - 4 Packs Mice Cubes (16 traps total) - Safe, Clean, Silent, Reusable - IT WORKS!! The Mice Cube is a molded plastic mousetrap with a door that is f... Read More >

If you're new here, you may want to subscribe to the mailing list to get notifications of new post and a virtual tour of past topics. Thanks for visiting!