TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
younis abdeljawwad
NA
73
96.9k
how to check the date in the table
Jun 20 2012 2:28 PM
Hi all,
am developing desktop application on visual studio 2010 professional using c#,
i have table that have two columns start_date and end_date, these values is taken from DateTimePicker and stored in the table ( like this format 5/28/2012)
now i want to add another item that have start_date and end_date, how can i check is the new item start and end date is not between any other old item start and end date in the table in the database,
i mean the start and the end of any item date in the table data is not like any other , every item have unique start and end date
if conflict in date a message is appear that i have conflict in date and i should add a new date start and end that is not exist in the table data
thanks all
Reply
Answers (
2
)
How to save Image in Sql server 2008
Sparse Columns in SQL Server