I have a sql stored procedure, and I am trying to add an if statement to the sql script. however I keep getting an error message of : "Incorrect syntax near the keyword 'THEN'.
I then tried making the most simple if statement shown below, and I still get the same error message.
IF 'A' = 'A' THEN SELECT 'Succes'
What am I doing wrong?