How Should i get between one date to another date in sql ?

Question

I have a table In sql server. see example Event Id = 4 ,

 

Event_Startdate is 2014-06-01  and Event_EndDate  is 2014-07-10.

 

But My Qusetion is that if I am giving Event_Startdate 2014-06-02 and Event_EndDate 2014-07-08 then not insert record else insert record .

and messges should display error message.

 

This user given date check all record in same table. not only one date, one id.

 

if user given  Event_Startdate 2014-06-02 and Event_EndDate 2014-07-08 then check all recoreds not only one record.

 

How should i do this? Please help.