PostList

MS SQL STRING_ESCAPE

MS SQL STRING_ESCAPE

MS SQL STRING_ESCAPE introduced in MS SQL 2016 escapes special characters in texts and returns text with escaped characters....

Read More
MS SQL STRING_SPLIT

MS SQL STRING_SPLIT

Let's talk about MS SQL STRING_SPLIT table-valued function introduced in MS SQL version 2016 for splitting string values by a separator. How we did it before and test its performance compared to the old way. We will also see the pros but also cons of the function....

Read More
MS SQL STRING_AGG

MS SQL STRING_AGG

In this post we will learn something about MS SQL STRING_AGG function introduced in MS SQL version 2017 for string aggregation, how we did it before and test its performance compared to the old way....

Read More
MS SQL CONCAT vs CONCAT_WS

MS SQL CONCAT vs CONCAT_WS

SQL Server function CONCAT is introduced in MS SQL version 2012. Simple as that it returns a string that is the result of concatenating two or more string values. Let’s compare it with the new function CONCAT_WS which is introduced in MS SQL Server 2017....

Read More
MS SQL FORMATMESSAGE

MS SQL FORMATMESSAGE

Read more about MS SQL FORMATMESSAGE function introduced in MS SQL 2016. Find samples and explanations. Let's find how to use it and what has in common with the C# String.Format() method....

Read More
MS SQL TRIM

MS SQL TRIM

TRIM is a new MS SQL Server function introduced from MS SQL Server 2017. It removes space characters from both sides (at the beginning/left and at the end/right) of the given string value. You can read more in this post....

Read More