Parameter Field

[luvmy2kids]

I have a parameter @date. I want it to be setup as to where it can accept a date of it one is not passed in, it defaults to getdate(). How can I go about doing that?

Declare @date datetime
Set @date = ?????

Thanks!

 

[bborissov]

IF @Date IS NULL
   SET @DATE = GETDATE()

or if it is in SP

CREATE PROCEDURE WhatEver (
       @Date datetime = GETDATE(),
...

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[gmmastros]

Sounds to me like you want it to be an optional parameter. You cannot set an optional parameter to use GetDate(). But... you can set an optional parameter to be NULL and within the stored procedure set it to GetDate(), like this...

Create Procedure Whatever(@Date DateTime = NULL)
As
SET NOCOUNT ON

Set @Date = Coalesce(@Date, GetDate())

-- Use the @Date parameter

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom