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.
SELECT MAX(OBJECT_ID) FROM sys.objects
______________________________________
SELECT MIN(OBJECT_ID) FROM sys.objects
______________________________________
SELECT COUNT(OBJECT_ID) FROM sys.objects
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 SQLAuthority.com and technology evangelist.