Incorrect syntax near ‘)’ calling stored procedure with GETDATE

by

You can’t pass in a function call as an argument to your stored procedure. Instead use an intermediate variable:

DECLARE @tmp DATETIME
SET @tmp = GETDATE()

EXEC DisplayDate @tmp;

More Related Contents:

  1. SQL Server – error when creating stored procedure
  2. How can foreign key constraints be temporarily disabled using T-SQL?
  3. Pad a string with leading zeros so it’s 3 characters long in SQL Server 2008
  4. Does T-SQL have an aggregate function to concatenate strings? [duplicate]
  5. Datatype for storing ip address in SQL Server
  6. Is there a way to loop through a table variable in TSQL without using a cursor?
  7. Maximum size of a varchar(max) variable
  8. best way to convert and validate a date string
  9. How to get a date in YYYY-MM-DD format from a TSQL datetime field?
  10. How do I format a number with commas in T-SQL?
  11. How to set a default value for an existing column
  12. Need a datetime column in SQL Server that automatically updates when the record is modified
  13. Is there a way to simplify a NULL compare of 2 values
  14. TSQL Try / Catch within Transaction or vice versa?
  15. What is the maximum number of characters that nvarchar(MAX) will hold?
  16. How do I find a stored procedure containing ?
  17. TSQL: Create a view that accesses multiple databases
  18. Sequence as default value for a column
  19. Aggregate bitwise-OR in a subquery
  20. How do I flush the PRINT buffer in TSQL?
  21. Get ROWS as COLUMNS (SQL Server dynamic PIVOT query)
  22. OR Operator Short-circuit in SQL Server
  23. How to change default language for SQL Server?
  24. T-SQL incrementing counter based on change in a column value
  25. T-SQL XOR Operator
  26. ADO.NET calling T-SQL Stored Procedure causes a SqlTimeoutException
  27. @@ERROR and/or TRY – CATCH
  28. “If not exists” fails on SQL CE
  29. Does the `nodes()` method keep the document order?
  30. How to calculate difference in hours (decimal) between two dates in SQL Server?

Leave a Comment