Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

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

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

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

Home
Forums

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

Amrul Hakim

9yAsked May 21, 2017, 8:28 AM901

This My Table Stock:

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Nilesh Shah9y ago
Accepted answer
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
Amrul Hakim9y ago
you can show me example code?
Nilesh Shah9y ago
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