Incorrect syntax near ')' calling storedproc with GETDATE

Posted by Nat on Stack Overflow See other posts from Stack Overflow or by Nat
Published on 2010-03-08T03:21:44Z Indexed on 2010/03/08 3:30 UTC
Read the original article Hit count: 235

Filed under:
|
|

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

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about tsql