2016-05-26
1,504 reads
2016-05-26
1,504 reads
The difference between the CONCAT function and the STUFF function lies in the fact that CONCAT allows you to append a string value at the end of another string value whereas STUFF allows you insert or replace a string value into or in between another string value. Read on to learn more about these functions and their real life usage.
2015-05-01
9,908 reads
2013-08-22
2,363 reads
TSQL provides 2 ways to concatenate data, the + sign and the new CONCAT() function. This tip will cover the differences in the two, so you can achieve the expected behavior in your code.
2013-08-07
3,623 reads
2013-07-09
3,295 reads
This article shares some tips on using concatenation efficiently for application development, pointing out some things that we must consider and look at when concatenating values or fields in our queries or stored procedures.
2012-11-06
3,661 reads
By Steve Jones
I was renewed this week as a Microsoft MVP. This is my 15th award...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Comments posted to this topic are about the item Establishing a Connection to PostgreSQL...
I am trying to create an SSIS package inside Visual Studio 2019. This package...
I have files in Blob Storage that I'd like to copy over to a...