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.

Tapan Patel · Answer

Please clarify the question little bit. It sounds confusing. If you are looking for inserting records only if the given Event_StartDate and Event_EndDate exist then try query like : (You may want to parameterized your query if you are doing it from code) SELECT EventId FROM Table WHERE Event_StartDate= 2014/06/02 AND Even_EndDate= 2014/07/08 If the output of the above query is null you need not to insert the record. If the output of the above is not null you need to insert the record.