SQL SERVER Stored Procedure and Transactions
Posted
on Dot net Slackers
See other posts from Dot net Slackers
Published on Wed, 02 Jun 2010 00:00:00 GMT
Indexed on
2010/06/02
2:55 UTC
Read the original article
Hit count: 178
Filed under:
I just overheard the following statement – “I do not use Transactions in SQL as I use Stored Procedure“. I just realized that there are so many misconceptions about this subject. Transactions has nothing to do with Stored Procedures. Let me demonstrate that with a simple example. USE tempdb GO --Create3TestTables CREATETABLE TABLE1 (ID INT); [...]...
Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.
© Dot net Slackers or respective owner