create PROCEDURE testdate @date1 datetime, @date2 datetime AS if(@date1!=@date2)begin SELECT datecreated FROM tablename WHERE datecreated BETWEEN @date1 AND @date2 end else begin select * from tablename end
select * from table where table.DateColumn >= @StartDate AND table.DateColumn <= @EndDate
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)