Search code examples
sqlsql-serverstored-proceduresclrstoredprocedure

ms sql call stored procedure with date time parameter


how do one call a stored procedure that has date input .

spName getDate()

does not work.

the question is about calling within ms sql managment studio.


Solution

  • SQL Server 2008

    declare @d date = getdate() /*Or datetime looking at the title*/
    exec spName @d
    

    Earlier Versions

    declare @d datetime
    set @d = getdate()
    exec spName @d