Tags

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


SQL PUZZLE | CATCH ” Msg 207, Level 16, State 1, Line 13 Invalid column name ‘Id1’. ” Puzzle | SQL INTERVIEW QUESTION

In this puzzle you have to explain why we are not able to catch the Invalid column name exception. We also need to change our code to catch this kind of exception. For more details please refer sample input and expected output

Sample Data with QUERY

--

CREATE TABLE Ex
(
	Id INT 
)
GO

BEGIN TRY
    SELECT Id1 FROM Ex
END TRY
  BEGIN CATCH
    PRINT ERROR_MESSAGE();
END CATCH
GO

--

Expected OUPUT as the error message [in Black Color]

--

Invalid column name 'Id1'.

--

Solutions 🙂

SOLUTION 1 | Use Dynamic SQL while calling the SELECT

--

BEGIN TRY
    EXEC('SELECT Id1 FROM Ex')
END TRY
  BEGIN CATCH
    PRINT ERROR_MESSAGE();
END CATCH

--

OUTPUT 1

--

Invalid column name 'Id1'.

--

Notes – Try does not handle this kind of error. It can only handle certain types of errors within its own scope. Please read more from Microsoft from below references.

References

# URL
1 https://docs.microsoft.com/en-us/sql/t-sql/language-elements/try-catch-transact-sql
2 https://technet.microsoft.com/en-us/library/ms179296(v=sql.105).aspx

Add your solution(s) in the comments section or send you solution(s) to pawankkmr@gmail.com

Add a comment if you have any solution in mind. I would love to learn it. We all need to learn.

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