MSSQL - Stored Procedure Error - Incorrect syntax near the keyword 'CASE'.
Posted on 2007-07-26
Hi guys 'n gals,
I have a problem with my CASE statement in my stored procedure, could somebody help me please?
Incorrect syntax near the keyword 'CASE'.
Incorrect syntax near the keyword 'END'.
My stored procedure:
CREATE PROCEDURE [sp_Test]
THEN DELETE FROM tblTemp WHERE UID=@value
Any idea on what I need to change?