March 16, 2015

SQL Quiz – Why Error when Executing SELECT statements

by pug-admin in SQL Server 0 comments

Let us start our very first blog post with a quiz. Thanks Pune User Group for inviting me for the guest blog post. Run following T-SQL Code in SSMS. There are total of five lines. Three T-SQL statements separated by two horizontal lines.


Now when you execute individual lines only it will give you error as

Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure ‘______________________________________’.

However, when you executed all the five statement together it will give you following resultset.


What is the reason of the same?

Please post your answer in the comments section. If you cannot figure out the answer here is the hint.

Author: Pinal Dave is principal author of and technology evangelist.


Leave a comment