2024-09-04
476 reads
2024-09-04
476 reads
2024-08-21
497 reads
2016-05-26
1,513 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,375 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,304 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 DataOnWheels
Hey data friends! This blog is to discuss an edge case I’ve run into...
By Steve Jones
I was experimenting with a local model (article) and as a part of this,...
By Steve Jones
Redgate Monitor has grown tremendously from its early days and I find many customers...
I want to transpose sql table rows to columns. I have written a query...
Hi all, I hope someone can help with advice. What would be the best...
Comments posted to this topic are about the item Sparse Column Defaults
What are the restrictions for defaults on columns declared as sparse?
See possible answers