PostList

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