SQL Triggers in Tamil | Easy Explanation with Examples

[@jeevarj-q4u]

Great explanation

[@sps3831]

Thank you mam.... I pass the exam... 🎉

[@TechWithHema]

Congrats @sps3831, I'm glad that my video helped you.

[@yuvasreer1693]

Simple explanation mam. It was easy to understand thank you

[@HarilakshmiHarilakshmi-f4x]

Thank you so much for your explanation mam 🙏 😊

[@mathspulligal7460]

Super Mam First Class Explanation with Query with Example

[@halstein1]

Excellent explanation!!! Thank you

[@rajeshkumarraj7423]

Super thanks lots of u madam

[@Bharathvaj2828]

TQ for this video Mam😊

[@kedarnathk6326]

Really a nice video madam.clear understanding.Thanks for your efforts.Please make more videos related to PLSQL functions.My kind request is to plz teach us the cursor and its uses like the trigger video

[@TechWithHema]

Sure, thanks @kedarnathk6326

[@shivaselvan8858]

Thanks! Your content is awesome. Keep rocking!

[@9322693481]

Nice video Mam

[@sivaranjani1500]

Tq for this video😊

[@gnanavarsharaman2592]

Amazing❤

[@TarotWorld-ur7ln]

Perfect explanation

[@SOWMIYAR-y4d]

Mam upload SQL project...it's very helpful

[@saravananchidambaram3569]

Good explanation

[@palanissamy6881]

super Hema

[@poongodibanu2036]

This is sql server super mam pls teach us oracle plsql triggers mam

[@mullaipugazhendi3236]

Hi please upload a video on SQL performance tuning.

[@TechWithHema]

Sure @mullaipugazhendi3236

[@shivaselvan8858]

@@TechWithHema Yes, please

[@Entertainment-77m]

store procedurela function eppadi call pannalam and scalar fuction na enna and table value function and user difined function

[@TechWithHema]

Sure @tamilarasanparivallal9196

[@malathir3348]

Tnk you mam❤

[@karthikeyanskk9762]

Visual basic 6 yeppadi use panni program pandradhu nu video podunga

[@giridharanmahesh9233]

Hi Mam i used the query that you used in the video for creating a trigger and i am getting syntax error near ON

[@TechWithHema]

I'm using MSSQL, if you are using a different DBMS, you may get an error.

[@mohamedhusain7807]

thank you

[@rajmathichithramani]

HI hema ...i have doubt... To delete commands after using triggers....the records are deleting in Original table.... But in virtual table that deleted records are available na ....those records are consuming memory which is in virtual table??....Please help on this...

[@TechWithHema]

Hi, "DELETED" table is just a temporary table and its memory gets released automatically once the trigger is completed. The cause for more memory consumption can be due to other reasons. Like, if you are deleting a large dataset, it may increase transaction log size, just ensure if you have correctly sized them. Or try to split the delete in to small batches in case of large datasets and also have a look at the index management.

[@magarajothik3144]

mam please upload MsSQL Full tutorial video mam

[@TechWithHema]

Sure @magarajothik3144

[@lathankumar5868]

Hi sis,delete the one record based on employees id in case we have select name it will delete it can be store empaudit table same query??

[@TechWithHema]

Sorry @lathankumar5868, I couldn't understand your question. Can you explain in detail?

[@lathankumar5868]

Employees id base pani 1 record delete pana employee audit table store agum so Athu va name instead of id use pani delete pana audit table store aguma same query sis..

[@TechWithHema]

Hi@@lathankumar5868 You can use any filter to delete the records and those deleted records will get saved in the audit table. If you want other details of the employee like `to be stored in the audit table, add required columns to the audit table and make changes in the select statement in the trigger to include those columns.

[@lathankumar5868]

@@TechWithHema thank you

[@muthulakshminagarajan48]

nosql paththii sollunga sis

[@sivaranjani1500]

Can you plz update events video also

[@TechWithHema]

Hi @sivaranjani1500 events are available in MYSQL. Equivalent for events in MSSQL is Sql Server Agent jobs. I can make a video about that.

[@sivaranjani1500]

Tq for replying me 😊

[@Entertainment-77m]

mam eththanai type of parameter irukku and atha eppadila use pannalam atha outputla eppadi prinmt pannalam atha slunga mam

[@TechWithHema]

Hi @tamilarasanparivallal9196 you can check out my Stored procedure video where I have explained about input and output parameters.

[@Entertainment-77m]

But I want explain deeply mam using many number of parameter same time

[@TechWithHema]

sure @@Entertainment-77m

[@SARAVANAKUMARK-h8b]

sql query optimize need hema

[@BusinessandKnowledge-sk8wu]

I need elborate session from trigger

[@Muruga_bhakthan]

indha method epadi mysql la work out pandradhu

[@prasannami6421]

Same query i execute in my laptop, but it is not executing and showing error.... Why

[@TechWithHema]

Hi @prasannami6421, Are you using MSSQL? What is the error message?

[@prasannami6421]

I am using Oracle SQL

[@TechWithHema]

Hi @prasannami6421 There are syntax differences between them. You can try something like this in oracle.
CREATE OR REPLACE TRIGGER trg_emp_audit
BEFORE INSERT ON employees
FOR EACH ROW
BEGIN
INSERT INTO employees_audit
VALUES (:NEW.EMPLOYEE_ID, 'INS', SYSDATE);
END

[@prasannami6421]

I have tried and got the answer madam...
Are you able to guide the Procedure lecture ( I need from root level with basic concepts... If possible a graphical explanation)... I think you are a master in SQL so only asked

[@TechWithHema]

Hi @@prasannami6421 , Are you looking for Stored procedure topic? You can find in this link th-cam.com/video/vJOsW41S16E/w-d-xo.html

[@SANDY-nk7vn]

Why you're using UNION ALL in between insert and delete?

[@sapb1tamil]

Good explanation