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
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