i need to get alldata whereclause in sql?

Question

i need to take all data if Page!=@page, get AllDATA

select count(page) as TARIH,
(datepart(hour,Date)*60+datepart(minute,Date))/@countgap as SIRA
from scr_SecuristLog
where Date between @date1 and @date2 and Page=@page or Page = AllDATA

Answer 1

try:

select
    count(page) as TARIH
        ,(datepart(hour,Date)*60+datepart(minute,Date))/@countgap as SIRA
    from scr_SecuristLog
    where Date between @date1 and @date2 and (Page=@page or Page = AllDATA)

Answer 2

Solution: select count(page) as TARIH,
(datepart(hour,Date)*60+datepart(minute,Date))/@countgap as SIRA
from scr_SecuristLog
where Date between @date1 and @date2 and (Page=@page or @page='Tüm Kullanıcılar')

Answer 3

select count(page) as TARIH,
(datepart(hour,Date)*60+datepart(minute,Date))/@countgap as SIRA
from scr_SecuristLog
where 
    Date between @date1 and @date2 
    and 
    (
     (@page is not null and Page=@page) 
     or (@page is null and @page=@page)
    )

will return all data between date1 and date2 and only data equal to the parameter, or if the parameter is null will return all data between date1 and date2