New For SQL Server 2017: T-SQL Function CONCAT_WS

2018-03-29 0 Comments

Dave Mason SQL Server 2017 TSQL CONCAT_WS

In the last post, I looked at a new T-SQL function for SQL Server 2017. Let's continue down that path and look at CONCAT_WS(), which is also new for SQL Server 2017. Here's the definition of the function from Microsoft Docs:

0 comments:

New For SQL Server 2017: T-SQL Function TRIM

2018-03-23 0 Comments

Dave Mason SQL Server 2017 TSQL TRIM

There's a new T-SQL function for SQL Server 2017 named TRIM(). If you're familiar with LTRIM() and/or RTRIM(), you can probably guess what it does. Here's the definition of the TRIM() function from Microsoft Docs:

0 comments:

STRING_AGG Return Types

2018-03-04 2 Comments

Dave Mason SQL Server STRING_AGG

I had a chance to use the STRING_AGG function recently, or so I thought. Since I couldn't use it for "real world" work, I decided to give it a test drive on my own. My initial thought was to do some performance testing and blog about that, but I ran into an interesting problem that I'll discuss here for now.

I started by populating a table with some "string" data:

2 comments: