Incorrect syntax near ')' calling storedproc with GETDATE
- by Nat
Maybe I am having a moment of 'afternoon', but can anyone explain why I get
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near ')'.
When running
CREATE PROC DisplayDate
(
@DateVar DATETIME
) AS
BEGIN
SELECT @DateVar
END
GO
EXEC DisplayDate GETDATE();