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();