Welcome to Rayz.com

Archive for the ‘SQL’ Category

SQL Coalesce “Duh”

Monday, February 10th, 2014

As some may know, the SQL COALESCE statement will replace any nulls it finds with some other value. This function is a rock and staple of coding in SQL. It is similar to the ISNULL SQL function except it returns the non-null value instead of a boolean without having to write an “if” statement, and is extremely useful in “SELECT” statements.
Continue Reading…

SQL Joins

Friday, January 10th, 2014

Here is a picture that one of my buds sent me. It explains SQL joins to me better than just about anything I’ve seen in the textbooks. Hope it helps.

Continue Reading…