here is an example you may have to change according to your table: CREATE TRIGGER trg_Update_Qty ON Stock AFTER UPDATE AS UPDATE Stock SET Keterangag = 0 FROM inserted WHERE inserted.qty = 0 and inserted.kode_barang = Stock.kode_barang GO please mark the answer as accepted if it satisfies your question

I assume you want to delete the data in the last column from table when qty = 0. write a trigger on that table in check if qty=0, then delete data in last column i.e. set it to 0