The SQL YEAR function evaluates the input date and returns the year part as an integer.Description The YEAR function works the same

Read More
SQL YEAR Function (Transact SQL)

The SQL CEILING function returns the smallest integer value greater than or equal to the input value. Description The CEILING function evaluates

Read More
SQL CEILING Function (Transact SQL)

Using NULLIF to compare missing values to NULL is handy. It become especially useful when you find yourself working with a column

Read More
Using NULLIF with Missing Values

When working with NULL, you’ll often find yourself wanting to replace these “missing” values, with something else. Just use ISNULL to do

Read More
Replace Missing Values in your Queries using ISNULL

The SQL UPPER function converts the input character expression to an upper case and returns it. Description The UPPER function reads the

Read More
SQL UPPER Function (Transact SQL)