For SQL Server 2012 or later, your first code block should work, even if the columns are not already strings:
CONCAT (Transact-SQL) - SQL Server | Microsoft Docs[
^]
The second code block would not work, since SQL Server doesn't use
"
for strings.
If you're using a different DBMS, you will need to tell us which one.