Morten Empeños Blog

Search:

Mixing Literals and Column Names in TSQL

Posted on Feb 02, 2015 by Morten Empeño

In this blog, I show how to mix literals and column names, and I explain how it can be useful to do so in specific contexts. All the naming of the columns is done with help from using aliases.

Read More

Categories: Database

Tags: SQL Aliases

COALESCE versus ISNULL

Posted on Feb 12, 2015 by Morten Empeño

T-SQL supports two functions to replace a NULL value with another value. This blog discusses nature of the ISNULL and the COALESCE functions, and concludes why one of the functions is often preferred by T-SQL developers.

Read More

Categories: Database

Tags:

CAST versus CONVERT

Posted on Feb 14, 2015 by Morten Empeño

In this very short blog I talk about how to use CAST and CONVERT in context of concatenate with nonstring values. I talk about how CAST, CONVERT can help you, when you want to convert a nonstring data type into a string.

Read More

Categories: Database

Tags:

SQL Junction Tables

Posted on Feb 26, 2015 by Morten Empeño

In this blog I explain how you can use a junction table, to establish a many to many relationship between two simple tables.

Read More

Categories: Database, T-SQL

Tags:


Page 1 of 1

Categories

Tags