SQL SERVER – Reasons for Using Output Clause – Quiz – Puzzle – 10 of 31

SQL Server Interview Questions and Answers
Print Book Available (207 Pages) | Sample Chapters

Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was a constant request from the Community to take the learning of these books to the next level. Here is an article which discusses the Author’s Perspective.

Beyond Relational has come up with a very interesting concept – they have converted a few of the questions from my book into the SQL Quiz. The quiz is indeed focused on my two goals. In addition, it’s going to put the learning of the book to a higher stage. Looking at this novel concept, Vinod Kumar (Co-author) and I have decided to help every participant and reader by giving a few hints and suggestions to solve the quiz.

SQL Quiz

I noticed a very long stored procedure in the production database. This database creating temporary tables, using insert and select statement. When I asked the purpose of the stored procedure, I realize they should have just used an OUTPUT clause. What is the OUTPUT clause inside SQL Server?

Link to participate in SQL Quiz

Notes of Vinod Kumar

The feature which got introduced in SQL Server 2005 edition had a lot of scope for usage. UC wrote a great post a while back on this subject on sqltips. Also, try to read more about the composable DML concepts.

Notes of Pinal Dave

When OUTPUT clause was introduced, I was very happy because I do not have to use global functions and temporary tables to accomplish certain tasks as this new clause. The OUTPUT clause has a variety of ways to access inserted and deleted tables (virtual tables). The OUTPUT clause can be used with INSERT, UPDATE, or DELETE to identify the actual rows affected by these statements.

Additional Notes

SQL Server Interview Questions and Answers ISBN: 1466405643 Page#63
OUTPUT Clause Example and Explanation with INSERT, UPDATE, DELETE

Prize

There are exciting prizes awaiting the winners. Click here for Prizes and Frequently Asked Questions.

Link to participate in SQL Quiz

Note: The SQL Quiz, winners and prizes are administrated by Beyond Relational. The goal of this blog post is to provide additional learning pointers only.

Reference: Pinal Dave (http://blog.sqlauthority.com)

About these ads

2 thoughts on “SQL SERVER – Reasons for Using Output Clause – Quiz – Puzzle – 10 of 31

  1. Pingback: SQL SERVER – A Quick Look at Logging and Ideas around Logging « SQL Server Journey with SQL Authority

  2. Pingback: SQL SERVER – Weekly Series – Memory Lane – #011 « SQL Server Journey with SQL Authority

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s