Once in a while we should laugh and relax. Here are few of my favorite funny one liners which I often use in my presentations. Let us start-
Just read that 4,153,237 people got married last year, not to cause any trouble, but shouldn’t that be an even number?
The EXCEPT operator returns all of the distinct rows from the query to the left of the EXCEPT operator when there are no matching rows in the right query. The EXCEPT operator is equivalent of the Left Anti Semi Join. EXCEPT operator works the same way NOT IN. EXCEPTS returns any distinct values from the query to the left of the EXCEPT operand that do not also return from the right query.
My friend sent me this in an email two days ago as he wanted me to have SQLAuthority T-Shirt with this image. I found it funny, I am not sure if I will have this on SQLAuthority T-Shirts. Please pay attention to the options available to select. I spend more than 3 hours to find the original source as my friend did not remember the source. Let’s see some SQL Humor here:
SQL Code Formatting is very important. Every SQL Server DBA has its own preference about formatting. I like to format all keywords to uppercase. Following are two online tools, which formats SQL Code very good. I tested following script with those tools and I found two of the tools worth mentioning here.
In this blog post we will see how we can convert ASCII to Decimal and Decimal to ASCII. In simple words, we will see the decimal and ASCII conversion.
The large majority of math functions is specific to applications using trigonometry, calculus, and geometry. This is very important and it is very difficult to have all of them together at place.