SQL Server The SQL Server ISNULL() function lets you return an alternative value when an expression is NULL:

The SQL CASE Expression The CASE expression goes through conditions and returns a value when the first condition is met (like an if-then-else statement). So, once a condition is true, it will stop reading and return the result. If no conditions are true, it …

SQL Server has many built-in functions. This reference contains string, numeric, date, conversion, and some advanced functions in SQL Server.

Definition and Usage The IFNULL () function returns a specified value if the expression is NULL. If the expression is NOT NULL, this function returns the expression. Syntax

SQL is a standard language for storing, manipulating and retrieving data in databases. Our SQL tutorial will teach you how to use SQL in: MySQL, SQL Server, MS Access, Oracle, Sybase, Informix, Postgres, and other database systems.

Aug 25, 2017 · Definition and Usage The CAST () function converts a value (of any type) into a specified datatype. Tip: Also look at the CONVERT () function. Syntax

The SQL SUM () Function The SUM() function returns the total sum of a numeric column.

You completed the SQL NULL Functions Exercises from W3Schools.comI completed a SQL exercise on w3schools.com

The SQL WHERE Clause The WHERE clause is used to filter records. It is used to extract only those records that fulfill a specified condition.

What is a Stored Procedure? A stored procedure is a prepared SQL code that you can save, so the code can be reused over and over again. So if you have an SQL query that you write over and over again, save it as a stored procedure, and then just call it to execute it.