Skip to main content

SQL SERVER – Puzzle – Write a Shortest Code to Produce Zero


Originally Posted by: Pinal Dave @ SQLAuthority
https://blog.sqlauthority.com/2017/08/24/sql-server-puzzle-write-shortest-code-produce-zero/

Image Source: https://fr.fotolia.com/tag/quiz



Pinal Dave is someone whose blogs I've followed for years, probably almost a decade. He has posted a puzzle on his website. If you know the answer, head over to the site, link above and respond!

Puzzle: Write a Shortest Code to Produce Zero
Conditions
1. Do not use numbers and arithmetic calculation
2. Do not use the function 'LEN()'
3. Do not use 0 in the code
4. Length of the entire code should be less than 19 characters

Good Luck!

Comments

Blogger said…
SELECT ISDATE('a') is 19 characters and therefore does not meet the rules.
My answer: SELECT @@ERROR on a fresh new window of SSMS.
Lavanya said…
Thank you for sharing wonderful information with us to get some idea about that content.
Microstrategy Training
Microstrategy Online Course
Lavanya said…
with us to get some idea about that content.Thanks for sharing
Microstrategy Online Training
Microstrategy Online Course