Reviews String SQl

Question

I note that Transact-SQL use + with many queries like this

SELECT PurchaseOrderNumber + ' (' + STR(RevisionNumber, 1) + ')' AS OrderRevision, CONVERT(nvarchar(30), OrderDate, 102) AS OrderDate FROM SalesLT.SalesOrderHeader;

'()' Why we use this Thanks

Answer 1

It's a simple + (String concatenation) (Transact-SQL) , a shorter way for writing a concat:

CONCAT (Transact-SQL)

Example:

select 'Hello ' + 'World'