Tags

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


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

In this puzzle you have to modify the query to handle the invalid column name. If we provide the proper column data then the query should return the proper data. If we provide the incorrect column name then the query should not fail.

Sample Data with QUERY

--

CREATE TABLE Ex
(
	Id INT 
)
GO

INSERT INTO EX VALUES ( 1 ) , ( 2 )
GO

--Query 1
SELECT Id FROM Ex

--Query 2
SELECT Id1 FROM Ex

--

Solutions 🙂

SOLUTION 1 – CASE WHEN Column Name is INCORRECT

--

SELECT p.Id1 Id 
FROM (SELECT NULL as Id1) x CROSS APPLY (SELECT Id1 FROM Ex) p
WHERE p.Id1 IS NOT NULL

--

OUTPUT 1

--

Id
-----------

(0 rows affected)

--

SOLUTION 1 – CASE WHEN Column Name is CORRECT

--

SELECT p.* 
FROM (SELECT NULL as Id) x CROSS APPLY (SELECT Id FROM Ex) p
WHERE p.Id IS NOT NULL


--

OUTPUT 2

--

Id
-----------
1
2

(2 rows affected)

--

Notes – I am not very sure where we need to use this. But if required we can use this simple trick.

References

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