Monday , September 25 2023

How To Concatenate Query Results in SQL Server(TSQL)

The other day I had to concatenate a query result. In this article, I’m going to tell you how to do this through an example.


Let’s create a table like below and add a few records into this table.

If we want to read the data in this table, we will see the result as follows.

Let’s concatenate this result set. You can perform this operation with the help of the following script.


About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *