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

Answers

How to make Trigger auto delete Column if stock Qty 0?

Amrul Hakim

287

1 COM Interop

This My Table Stock:

Answers (3)

Forum Statistics

Please welcome our newest member Jenica .
2,381,650 users have contributed to 122,515 threads and 389,026
In the past 24 hours, we have 0 new threads, 0 new posts, and 0 new users.
In last week, the most popular thread is 'what is generative Engine optimization'.

Upcoming Events

View all

How Gen AI is Reshaping Content, Code, and Commerce

Our Training Programs

View all

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

Live

How Gen AI is Reshaping Content, Code, and Commerce