I am using the SQL View to create my query and for some reason I do not get syntax highlighting.
My Query is:
DECLARE @var
SET @var = 10
SELECT @var
I get a syntax error.
This is, AFAIK, legal SQL code so there should be no problems.
Can you tell me what I am doing wrong?