How to get the range between dates in sql server

Question

I Created one stored procedure 

 

 

Create Procedure [dbo].[GetEmployeesDates]

@StartDate as varchar(50),

@EndDate as varchar(50)

as

begin

SELECT *

FROM [ERS].[dbo].[employee] where Date>=@StartDate and date<@EndDate

 

now

 

if i pass the parameters i need get the date between range

 

and also i need to get the date without passing the parameters 

 

how can i do this one

 

please help me 

thanks