Tuesday, July 23, 2013

Combine two columns value into one column using MSSQL

if want to select two column value in one culumn using MSSQL then you have to write below query

SELECT (column1+column2) AS columnName
FROM table


To add '-' beween value of these two column

SELECT (column1+ ' - ' + column2) AS columnName
FROM table

No comments:

Post a Comment