Tech
Forums
Jobs
Books
Events
Live
Interviews Prep
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
1
Reply
How Should i get between one date to another date in sql ?
Nirmal Roy
Jul 13 2017 4:24 AM
191
Reply
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.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
mutual friends query
How to concatenate columns without null value in sql