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 |
|
Mohamed Faisal
Yak Posting Veteran
51 Posts |
 Posted - 2014-10-12 : 05:09:46
|
| can anyone help me on the following:how to i write a trigger to enforce this constraint:A rental can be made only if the customer is registered with the company and the car is not currently rented out. If not, the rental will not be successful. |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-10-12 : 11:06:51
|
| it depends on your table structure. You need to post the CREATE TABLE commands for all the tables involved in this constraint. |
 |
|
|
|
|
|
trigger