Tags

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,


SQL PUZZLE | The OUTPUT Puzzles : 1 – SQL Interview QUESTION

In this post you have to go through the sample data/SQL/Query given below and answer the questions below.

Execute the below SP on your machine

--

CREATE PROC sadsadasdas
AS
BEGIN
	SELECT NULL a
END

EXEC sadsadasdas 
GO

--

Puzzles

Puzzle 1 : What is the OUTPUT of below query?

--

EXEC sadsadasdas 
GO

--

Answer
Notes – This will go in the infinite loop since there is a go missing after the procedure end.

--

a
-----------
NULL

(1 row affected)
..
..
..

Msg 217, Level 16, State 1, Procedure sadsadasdas, Line 7 [Batch Start Line 0]
Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).

--

Puzzle 2 : What is the OUTPUT of below query?

--

CREATE PROC RNULL
AS
BEGIN
	RETURN NULL
END
GO
EXEC RNULL 
GO

--

Answer
Notes – This will return the error message as we cannot return NULL from a stored procedure. We have a return a NON NULL integer value.

--

The 'RNULL' procedure attempted to return a status of NULL, which is not allowed. 
A status of 0 will be returned instead.

--

Puzzle 3 : What is the OUTPUT of below query?

--

CREATE PROC sada
AS
BEGIN
	SELECT NULL a
END
GO

EXEC sada 
GO

--

Answer
Notes – This will just give us NULL as the output as we are just selecting NULL. 🙂

--

a
-----------
NULL

(1 row affected)

--

Pawan Khowal

Pawan is a SQL Server Developer. If you need any help in writing code/puzzle or training please email at – pawankkmr”AT”gmail.com. Meanwhile please go throgh the top pages from his blog.

Page Detail URL
☛ SQL Advance Puzzles https://msbiskills.com/tsql-puzzles-asked-in-interview-over-the-years/
☛ SQL Tricky Queries https://msbiskills.com/sql-puzzles-finding-outputs/
☛ SQL Server Perfomance tuning Articles https://msbiskills.com/sql-performance-tuning/
☛ SQL Server Articles https://msbiskills.com/t-sql/
☛ SQL Interview Questions & Answers https://msbiskills.com/sql-server-interview-questions/

My SQL Groups on Facebook:

1. If you like this post, you may want to join my SQL SERVER Interview Puzzles/Interview Questions on Facebook: https://www.facebook.com/groups/1430882120556342/

2. If you like this post, you may want to join my SQL Server Puzzles on Facebook:
https://www.facebook.com/groups/206594023090781/

My SQL Page on Facebook:

2. For all the updates you may follow my page -> https://www.facebook.com/MSBISkillscom-1602779883299222/

Enjoy !!! Keep Learning

Http://MsbiSkills.com

Advertisements