datetime > @Variable

[Bell1991]

I am writing a stored procedure where i am passing in a date (although not required). If it is passed it, i want to select all the records with a date greater than that:

Select * from tblName
where column > @DateVariable

How do i check if null is passed in without writing several statements?

(i.e.,)
If (@DateColumn is null)
BEGIN

END
ELSE

 

[bborissov]

Select * from tblName
where column > ISNULL(@DateVariable, '19000101')

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[jdemmi]

Why don't you always pass it a value (give it a default value of 1/1/1901)?

-- Jason
"It's Just Ones and Zeros

 

[bborissov]

O!
I miss that you use Stored procedure.
Then just define it as :

CREATE PROCEDURE YourNameHere(
       ...
       @DateColumn datetime = '19000101'
       ...
AS
  BEGIN
      ....
      Select * from tblName
      where column > @DateVariable
  END
[code]


Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.