SQL SERVER – Stored Procedure and Transactions

6/2/2010

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 subjectTransactions has nothing to do with Stored Procedures.

Let me demonstrate that with a simple exampleUSE tempdb GO -- Create 3 Test Tables CREATE TABLE TABLE1 (ID INT); [...]

Full story: Journey to SQL Authority with Pinal Dave

Similar articles

DotNetShoutout - Latest published stories

SQL SERVER – Stored Procedure and Transactions « Journey to SQL Authority with Pinal Dave Learn the truth behind following statement - “I do not use Transactions in SQL as I use Stored Procedure“.

ASP.NET Weblogs

Passing Multiple Records to a Stored Procedure in SQL Server There are so many different ways to work with data that it can make your head spin. Regardless of the technology, one thing I always try to do when working with databases is minimize the number ...

Journey to SQL Authority with Pinal Dave

SQL SERVER – Encrypted Stored Procedure and Activity Monitor I recently had received question if any stored procedure is encrypted can we see its definition in Activity Monitor. No. Let us do quick test. Let us create following Stored Procedure and then launch ...

DotNetShoutout - Latest published stories

Load Dataset from SQL Server stored procedure Load data from Stored Procedure Loading data from stored procedures is essential for data bound applications. Executing stored procedures and retrieving data is not that difficult. With the use of SQ...

Journey to SQL Authority with Pinal Dave

SQL SERVER – Recompile Stored Procedure at Run Time I recently received email from reader after reading my previous article about SQL SERVER – Plan Recompilation and Reduce Recompilation – Performance Tuning that how to recompile any stored procedure a...

Journey to SQL Authority with Pinal Dave

SQL SERVER – System Stored Procedure sys.sp_tables I have seen people running the following script quite often, to know the list of the tables from the database: SELECT * FROM sys.tables GO The script above provides various information from create dat...

Comments on this article

Add your comment

Report

Latest from Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

SQL SERVER – A Puzzle – Fun with NULL – Fix Error 8117 During my 8 years of career, I have been many times interviewer and quite often interview candidate myself. If I am interviewer ...

Journey to SQL Authority with Pinal Dave

SQL SERVER – Standard Reports from SQL Server Management Studio – SQL in Sixty Seconds #016 – Video SQL Server management Studio 2012 is wonderful tool and has many different features. Many times, an average user does not use th...

Journey to SQL Authority with Pinal Dave

SQL SERVER – SmallDateTime and Precision – A Continuous Confusion Some confusion never go away. Here is the one of the ancient one. Precision of the SmallDateTime is the one concept/confusion I...

Journey to SQL Authority with Pinal Dave

SQL SERVER – Renaming Index – Index Naming Conventions If you are regular reader of this blog, you must be aware of that there are two kinds of blog posts 1) I share what I learn rece...

Journey to SQL Authority with Pinal Dave

SQL SERVER – New Look for CodePlexProject – Hosting for Open Source Software Codeplex is my favorite site. CodePlex is Microsoft’s free open source project hosting site. You can create projects to sh...

Journey to SQL Authority with Pinal Dave

SQL SERVER – Saturday Fun Puzzle with SQL Server DATETIME2 and CAST Note: I have used SQL Server 2012 for this small fun experiment. Here is what we are going to do. We will run the script one at ...

Journey to SQL Authority with Pinal Dave

SQL SERVER – Thinking about Deprecated, Discontinued Features and Breaking Changes while Upgrading to SQL Server 2012 – Guest Po Nakul Vachhrajani is a Technical Specialist and systems development professional with iGATE having a total IT experience of more...

Journey to SQL Authority with Pinal Dave

SQLAuthority News – SQL Server 2012 Upgrade Technical Guide – A Comprehensive Whitepaper – (454 pages – 9 MB) Microsoft has just released SQL Server 2012 Upgrade Technical Guide. This guide is very comprehensive and covers the subject of ...

Journey to SQL Authority with Pinal Dave

SQL SERVER – SQL in Sixty Seconds – 5 Videos from Joes 2 Pros Series – SQL Exam Prep Series 70-433 Joes 2 Pros SQL Server Learning series is indeed fun. Joes 2 Pros series is written for beginners and who wants to build experti...

Journey to SQL Authority with Pinal Dave

SQL SERVER – Get Schema Name from Object ID using OBJECT_SCHEMA_NAME Sometime a simple solution have even simpler solutions but we often do not practice it as we do not see value in it or find it u...

SQL SERVER – Stored Procedure and Transactions

Similar articles

DotNetShoutout - Latest published stories

ASP.NET Weblogs

Journey to SQL Authority with Pinal Dave

DotNetShoutout - Latest published stories

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Comments on this article

Latest from Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Sign In