CREATE TRIGGER trgCustomer_Deletion ON tblCustomers INSTEAD OF DELETE AS BEGIN DELETE c FROM tblcustomers c JOIN deleted d ON c.customerId = d.customerId WHERE NOT EXISTS (SELECT 1 FROM tblOrders WHERE customerId = d.customerId); END
Trouble logging in? Simply enter your email address OR username in order to reset your password.
For faster and more reliable delivery, add support@netstaircom.net to your trusted senders list in your email software.