Trigger in SQL | SQL Triggers | Triggers in SQL | SQL in tamil | Tech with Hema |
Вставка
- Опубліковано 2 жов 2023
- Trigger in SQL | SQL Triggers | Triggers in SQL | SQL in tamil | Tech with Hema |#sql #sqlintamil
Learn Trigger in tamil. You will see more videos in sql that will be coming soon. Please add your comments in the comment box if you like me to cover any other topics in sql that you are interested. Thank you.
Queries used in the video can be accessed through this link - drive.google.com/file/d/17cWo...
Installation of Microsoft SQL server and SQL server management studio - • Installation of Micros... - Наука та технологія
Thanks! Your content is awesome. Keep rocking!
Great explanation
TQ for this video Mam😊
Super thanks lots of u madam
Tq for this video😊
Perfect explanation
Good explanation
Thank you mam.... I pass the exam... 🎉
Congrats @sps3831, I'm glad that my video helped you.
Tnk you mam❤
This is sql server super mam pls teach us oracle plsql triggers mam
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
Sure, thanks @kedarnathk6326
Visual basic 6 yeppadi use panni program pandradhu nu video podunga
I need elborate session from trigger
Hi please upload a video on SQL performance tuning.
Sure @mullaipugazhendi3236
@@TechWithHema Yes, please
store procedurela function eppadi call pannalam and scalar fuction na enna and table value function and user difined function
Sure @tamilarasanparivallal9196
nosql paththii sollunga sis
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??
Sorry @lathankumar5868, I couldn't understand your question. Can you explain in detail?
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..
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.
@@TechWithHema thank you
mam please upload MsSQL Full tutorial video mam
Sure @magarajothik3144
mam eththanai type of parameter irukku and atha eppadila use pannalam atha outputla eppadi prinmt pannalam atha slunga mam
Hi @tamilarasanparivallal9196 you can check out my Stored procedure video where I have explained about input and output parameters.
But I want explain deeply mam using many number of parameter same time
sure @@tamilarasanparivallal9196
Can you plz update events video also
Hi @sivaranjani1500 events are available in MYSQL. Equivalent for events in MSSQL is Sql Server Agent jobs. I can make a video about that.
Tq for replying me 😊
Same query i execute in my laptop, but it is not executing and showing error.... Why
Hi @prasannami6421, Are you using MSSQL? What is the error message?
I am using Oracle SQL
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
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
Hi @@prasannami6421 , Are you looking for Stored procedure topic? You can find in this link ua-cam.com/video/vJOsW41S16E/v-deo.html