16h • General discussion
Daily Agenda 23-1-26
Assalamualaikum
Today I learned SQL Triggers
Aaj maine SQL Triggers seekhay, specially AFTER Trigger aur INSTEAD OF Trigger.
AFTER Trigger
Ye trigger tab execute hota hai jab INSERT, UPDATE ya DELETE operation successfully complete ho jaye.
Iska use hum mostly logging, audit trail, ya data validation ke liye karte hain.
INSTEAD OF Trigger
Ye trigger actual operation ki jagah execute hota hai, mostly Views ke sath use hota hai.
Iska matlab hai ke INSERT / UPDATE / DELETE ki original query run nahi hoti, balkay trigger ka logic run hota hai.
Triggers database me automatic actions perform karne ke liye bohat powerful feature hain.
3
1 comment
Daily Agenda 23-1-26
powered by
skool.com/make-1k-5k-in-30-days-8449
Media Valley School is the fastest way to hit $1K/month with freelancing or agency work. Guaranteed.
Land your first $1K month in 30 days
Suggested communities
Powered by