SQL tracking changes

Asked Nov 24 '14 at 08:40

Active Nov 24 '14 at 09:01

Viewed 46 times

Hi i have a view that contains:

ITEMID ITEMNAME STATUS
1001    BRICKS   1

And the table is updatated to:

ITEMID ITEMNAME STATUS
1001    BRICKS1111   1

and i want that status automaticaly would change to 0 when update/insert is made (it can be made from ERP software)

edited Nov 24 '14 at 09:01

asked Nov 24 '14 at 08:40

user2893780

Which DBMS are you using? Postgres? Oracle? – Nov 24 '14 at 08:41
2

[Database triggers](http://en.wikipedia.org/wiki/Database_trigger) – GolezTrol Nov 24 '14 at 08:42
If you are using MSSQL you can do this with a trigger: http://msdn.microsoft.com/en-us/library/ms189799.aspx – MFasseur Nov 24 '14 at 08:42
Yes its mssql, i'll read about triggers. Thank you! – user2893780 Nov 24 '14 at 08:50

0 Answers0