Today, let us see a very simple puzzle where we are getting strange results when using NOT IN and IS NULL in a T-SQL query.
SQL Puzzle – Schema and Table Creation – Answer Without Running Code
It has been a while we have a puzzle on this blog. Let us have a very simple and interesting puzzle today about Schema and Table Creation.
Winners and Solution – DELETE Qualified Rows From Multiple Tables
As the price of this class high, I wanted to keep my contest difficult as well. Today we will see the winners and solutions.
SQL SERVER – SQL Agent Job and Backslash – Strange Behavior
Today’s blog post is about SQL Agent Job and Backslash. I was surprised to see this behavior. Here are the steps to reproduce this behavior.
SQL Puzzle – DELETE Qualified Rows From Multiple Tables
Today we are going to see a very simple but brain teaser puzzle. This puzzle is about Deleting Qualified Rows From Multiple Tables.
SQL Puzzle – Correct the Incorrect Query – Win Price Worth USD 1000 – Aggregate and Subquery
A reader asked me to correct his query, and now it is your turn. Fix this Aggregate and Subquery puzzle on AdventureWorks for a chance to win a prize worth USD 1000.
SQL SERVER – Relating Unrelated Tables – A Question from Reader
A reader asked how to relate two unrelated tables, Table_A and Table_B, and show them in one output. Here is my answer to this unusual question.