Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.
ALTER TRIGGER trig_delOrderLineEntry /* This trigger will update the productlines qty when items are deleted from the orderline table mainly in the ordersummary and the session.end */ ON orderlines FOR DELETE AS DECLARE @qty int, @prodid int SELECT @qty = (SELECT Qty FROM Deleted) SELECT @prodid = (SELECT prodlineid FROM Deleted) UPDATE ProductLines SET StockLevel = StockLevel + @qty WHERE (id = @prodid)
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.