The CONCAT_WS String Function in SQL Server 2017

The CONCAT_WS String Function in SQL Server 2017 is a new function that provides more flexibility for string operations. Definition CONCAT_WS concatenates a variable number of arguments setting as a delimiter the first argument in the function. Examples Before checking out some examples of using CONCAT_WS, let’s create a temporary table with some sample data: CREATE TABLE … Read more…

What’s New in SQL Server 2017 Database Engine

SQL Server 2017 (also known as SQL Server vNext) and the new Azure SQL Database are finally here and they are generally available! In subsequent articles we will analytically examine every new feature using many examples.   SQL Server 2017 (and later) Now Also Supports Running on Linux and Docker Containers! In this post, we … Read more…