Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Gurdinho
Starting Member
1 Post |
 Posted - 2009-10-24 : 08:58:55
|
| Hey everyone, I have a problem about creating a trigger for the reservation system. Customer (customerID, title, firstName, familyName, specialRequirements, smokingFlag, emailAddress) <----- Customer TABLEReservation (reservationID, customerID, paymentID, checkIn, checkout, status) <------ Reservation TABLE (status can be "valid" or "cancelled")ConfirmationEmail (emailID, customerID, reservationID, emailText, emailSubject, dateSent) <------ ConfirmationEmail TABLE (emailTEXT = "The reservation is valid or cancelled")In this system, each time a new reservation is made, or an existing reservation is cancelled, the customer in question should be informed of it by an email. And I need to provide this notification to the customer by using "Trigger" in SQL.Do you have any suggestions?Thanks for your help and your ideas from now on.Have a nice weekend. |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
|
|
URGENT!!! Trigger Problem!