How do set up an sql trigger for a sales shop database to be subtracting goods sold and given the over quantity remained for sales made each day.

Using triggers to update inserted rows constantly.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

seanlange commented · Jul 29, 2016 at 08:58 PM

You need MORE than just an AFTER INSERT trigger if you want to have any chance at this. You will also need to handle UPDATES and DELETES. Honestly this type of stock calculation should be done on the fly as needed in most situations.

0 ·

anseakukwe14 commented · Jul 31, 2016 at 09:46 PM

seanlange, please explain well. what codes am I going to use?

0 ·

seanlange anseakukwe14 commented · Aug 01, 2016 at 01:13 PM

This should be a comment, not an answer. I couldn't possibly tell you what code to use here. I have no idea what your tables are like or what you are trying to do. I can tell you that in my opinion managing this via triggers is a lot more work than you think. If you can post your table definitions and an explanation of what you are trying to do I can help. Take a look at this for examples of what you should post. http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/

1 ·