This article will provide an understanding of how to effectively use group concatenation in MySQL.
Read more »
String Concatenation
String Concatenation Done Right – Part 2 – An Effective Technique
April 16, 2015Previously I have introduced string concatenation by demonstrating how not to use Transact-SQL to concatenate strings. In this part I will focus on XML composition, and will demonstrate how to correctly implement it in order to concatenate strings.
Read more »
SQL Concatenation Done Right – Part 1 – Dubious Practices
April 15, 2015This article is a part of three articles series to explore SQL Concatenation techniques.
Having to represent sets of data as strings is a very common requirement in information management, even in modern times where a variety of more or less elaborate standards for storing, and moving, data are at our disposal. For instance, XML, JSON, or similar techniques, allow the data to be extracted from one data source, using a well-known standard, and be stored temporarily until being loaded into a destination data store, or until being consumed in some other way. Actually, both XML as well as JSON might even be used as a standard way of storing data permanently; especially, if the consumers expect the data to use one or the other format.
Read more »