the following query:
DECLARE @ntp int,
@jugador varchar (max)= 'Hola',
@Player varchar (max)
SET @Jugador = @Player
EXEC @ntp = [PS_GameDefs].[dbo].[Command]
@serviceName = N'ps_game',
@cmmd = N'/ntplayer '+@Player+' '+ ' '+'Has ganado'
SELECT 'Return Value' = @ntp
GO
I get the error:
Msg 102, Level 15, State 1, Line 12
Incorrect syntax near '+'.
you can see that it is the "+" symbol that I think the query is fine but I can not explain why the error?