Nirmal Roy

Nirmal Roy

  • NA
  • 365
  • 27.3k

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

Jul 13 2017 4:24 AM
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. 
 
 
 

Answers (1)