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
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