Previously 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 »Matija Lah
Matija Lah, formally a university graduate of law, has been involved in information management since the nineties.
His first introduction to SQL Server in IUS Software d.o.o. Slovenija has later culminated in a new career developing data-centric solutions and consulting. His contributions to the SQL Server community have led to the Microsoft Most Valuable Professional award in 2007 (Windows Server System SQL Server).
Currently, most of Matija's time is spent on projects involving advanced information management, natural language processing, and knowledge management.
View all posts by Matija Lah
His first introduction to SQL Server in IUS Software d.o.o. Slovenija has later culminated in a new career developing data-centric solutions and consulting. His contributions to the SQL Server community have led to the Microsoft Most Valuable Professional award in 2007 (Windows Server System SQL Server).
Currently, most of Matija's time is spent on projects involving advanced information management, natural language processing, and knowledge management.
View all posts by Matija Lah
Latest posts by Matija Lah (see all)
- String Concatenation Done Right – Part 2 –An Effective Technique - April 16, 2015
- SQL Concatenation Done Right – Part 1 – Dubious Practices - April 15, 2015
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 »