Data Types and Functions Archives - Essential SQL

Home
|
Category: Data Types and Functions

Data Types and Functions

Using NULLIF with Missing Values

Using NULLIF to compare missing values to NULL is handy. It become especially useful ...

Data Types and Functions

Replace Missing Values in your Queries using ISNULL

When working with NULL, you’ll often find yourself wanting to replace these “missing” values, ...

Data Types and Functions

Use SQL Conversion Functions to Work with Different Data Types

Use SQL conversion functions to work with different data types. SQL server uses data ...

Data Types and Functions

Learn to use SQL Date Functions

SQL server’s date functions provide you a set of function that you can use ...

Data Types and Functions, General Updates

The New SQL Server Approximate Count Distinct Function

Use the Approximate Count Distinct function, APPROX_COUNT_DISTINCT, to return an estimate distinct count of ...

Data Types and Functions

SQL COALESCE Function and NULL

Knowing when to use the SQL COALESCE function is a lifesaver when you’re dealing ...