5>
6> SELECT 'Year: ' + CONVERT(VarChar(4), YEAR(GETDATE()))
7> ', Month: ' + CONVERT(VarChar(2), MONTH(GETDATE()))
8> ', Day: ' + CONVERT(VarChar(2), DAY(GETDATE()))
9>
10> GO
Msg 102, Level 15, State 1, Server J\SQLEXPRESS, Line 7
Incorrect syntax near '+'.