I am usins SQL server
I need to fire a trigger when an appointment for the same date comes.It should not allow more than one appointment for a hall booking system,how can i do that? iam using a table called appointment and the logic i used is take the date from the inserted table and check it with the app_date field from the appointment table.can any help me,thanks in adv,help is more appreciated.thanks again
mathewmoozh
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.