In SQL Server 2012, there are two new string functions being introduced, namely: CONCAT(), FORMAT(). In this blog post we are going to learn about String Function CONCAT(). CONCAT takes a minimum of two arguments to concatenate them, resulting to a single string.
I was very happy when books were published and I got a print copy in my hand. In this blog post we will discuss about Book Authoring.
In SQL Server 2012, there are two new logical functions being introduced, namely: IIF() and CHOOSE(). Today we will quickly take a look at the logical CHOOSE() function. This function is very simple and it returns specified index from a list of values. If Index is numeric, it is converted to integer. On the other hand, if the index is greater than the element in the list, it returns NULL.
In SQL Server Denali, three new conversion functions have been introduced, namely,
PARSE()
TRY_PARSE()
TRY_CONVERT()