How to merge multiple column into one column with same table in SQL Server?

Question

I need to merge some column value into one column with varchar/nvarchar data type.

I tried to use Computed Column Specification in Table Designer, but I only know how to compute int data type.

| Column1 |  | Column2 |  | Column3 |  |MergedColumn|
|    A    |  |    B    |  |    C    |  |    AB-C    |
|    A1   |  |    B1   |  |    C1   |  |  A1B1-C1   |

I need that result in MergedColumn.

You can try using concat the columns you want and update the last column. learn.microsoft.com/en-us/sql/t-sql/functions/… — Vlam
– Vlam, Commented Aug 16, 2019 at 2:15
I use concat as select, but I need the result like a normal column. — Panji
– Panji, Commented Aug 16, 2019 at 2:25
No, I think you could probably choose one or the other to do what you need. It sounds like you might have tried a computed column though it's unclear what you meant by the "int" thing. — shawnt00
– shawnt00, Commented Aug 16, 2019 at 4:45

Tim Biegeleisen · Accepted Answer · 2019-08-16 02:16:33Z

2

The CONCAT function should work here:

SELECT
    Column1,
    Column2,
    Column3,
    CONCAT(Column1, Column2, '-', Column3) AS MergedColumn
FROM yourTable;

answered Aug 16, 2019 at 2:16

Tim Biegeleisen

526k32 gold badges324 silver badges399 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Panji Over a year ago

How to place this syntax as column?

Vlam Over a year ago

ALTER TABLE yourTable ADD MergedColumn AS CONCAT(Column1, Column2, '-', Column3) PERSISTED that should do it.

Collectives™ on Stack Overflow

How to merge multiple column into one column with same table in SQL Server?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related