mathewmoozh 0 Newbie Poster

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

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.