Trigger in SQL | SQL Triggers | Triggers in SQL | SQL in tamil | Tech with Hema |

Подписаться 4,6 тыс.

Просмотров 22 тыс.

50% 1

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.c...
Installation of Microsoft SQL server and SQL server management studio - • Installation of Micros...

Опубликовано:

27 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 50

@mathspulligal7460 Месяц назад

Super Mam First Class Explanation with Query with Example

@shivaselvan8858 4 месяца назад

Thanks! Your content is awesome. Keep rocking!

@jeevarj-q4u 8 месяцев назад

Great explanation

@sps3831 11 месяцев назад

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

@TechWithHema 11 месяцев назад

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

@sapb1tamil 8 дней назад

Good explanation

@Bharathvaj2828 11 месяцев назад

TQ for this video Mam😊

@rajeshkumarraj7423 11 месяцев назад

Super thanks lots of u madam

@HarilakshmiHarilakshmi-f4x День назад

Thank you so much for your explanation mam 🙏 😊

@SOWMIYAR-y4d Месяц назад

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

@TarotWorld-ur7ln 3 месяца назад

Perfect explanation

@palanissamy6881 2 месяца назад

super Hema

@mullaipugazhendi3236 11 месяцев назад

Hi please upload a video on SQL performance tuning.

@TechWithHema 11 месяцев назад

Sure @mullaipugazhendi3236

@shivaselvan8858 4 месяца назад

@@TechWithHema Yes, please

@giridharanmahesh9233 29 дней назад

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

@karthikeyanskk9762 11 месяцев назад

Visual basic 6 yeppadi use panni program pandradhu nu video podunga

@tamilarasanparivallal9196 11 месяцев назад

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

@TechWithHema 11 месяцев назад

Sure @tamilarasanparivallal9196

@malathir3348 4 месяца назад

Tnk you mam❤

@magarajothik3144 11 месяцев назад

mam please upload MsSQL Full tutorial video mam

@TechWithHema 11 месяцев назад

Sure @magarajothik3144

@SANDY-nk7vn Месяц назад

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

@muthulakshminagarajan48 5 месяцев назад

nosql paththii sollunga sis

@SARAVANAKUMARK-h8b 2 месяца назад

sql query optimize need hema

@BusinessandKnowledge-sk8wu 3 месяца назад

I need elborate session from trigger

@tamilarasanparivallal9196 11 месяцев назад

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

@TechWithHema 11 месяцев назад

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

@tamilarasanparivallal9196 11 месяцев назад

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

@TechWithHema 11 месяцев назад

sure @@tamilarasanparivallal9196

@lathankumar5868 7 месяцев назад

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 7 месяцев назад

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

@lathankumar5868 7 месяцев назад

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 7 месяцев назад

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 7 месяцев назад

@@TechWithHema thank you

@prasannami6421 9 месяцев назад

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

@TechWithHema 9 месяцев назад

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

@prasannami6421 9 месяцев назад

I am using Oracle SQL

@TechWithHema 9 месяцев назад

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 9 месяцев назад

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 9 месяцев назад

Hi @@prasannami6421 , Are you looking for Stored procedure topic? You can find in this link ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-vJOsW41S16E.html

@saravananchidambaram3569 3 месяца назад

Good explanation

@mohamedhusain7807 19 дней назад

thank you

@kedarnathk6326 11 месяцев назад

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 11 месяцев назад

Sure, thanks @kedarnathk6326