SQL Server Programming Part 15 - DML Triggers

Поділитися
Вставка
  • Опубліковано 29 січ 2025

КОМЕНТАРІ • 38

  • @izapawlukowska4545
    @izapawlukowska4545 2 роки тому +3

    My TSQL test is tomorrow and your videos are my lifeline. Thanks a lot for your work.

  • @4am-withlearnuel
    @4am-withlearnuel 4 роки тому +1

    your are really good at this, you are not in a rush you take your time and explain every step of the way. Your really helping with this good work. No matter how tough the topic once i go through you tutorial i understand perfectly

  • @emielvanbelle7352
    @emielvanbelle7352 4 роки тому +2

    This man is an actual legend

  • @ddunn10
    @ddunn10 11 років тому +3

    Thank you so much for posting this video. I have a final exam coming up and I've been leaning heavily on your videos to get me through this semester of SQL Server 2012 !

  • @saagarsoni3
    @saagarsoni3 11 років тому +1

    sir very quality teaching for SQL tutorials.....awesome.....all your videos are very crystal clear....thanx a lot...thnx...

  • @sweetsazd11
    @sweetsazd11 7 років тому +1

    Your videos are super simple and easy to understand! Thank you :)

  • @fadwa2413
    @fadwa2413 3 роки тому +1

    EXCELLENT AS USUAL Andrew!!
    Thanks a lot

  • @8Kexperience
    @8Kexperience 10 років тому +4

    Good work! Keep it up.

  • @vladilucz2833
    @vladilucz2833 7 років тому +1

    this tutorial is absolutelly great, keep up the good work, really helpfull

  • @dheerajlxst9141
    @dheerajlxst9141 7 років тому

    Thank you this really helps me prepare for my exam!

  • @ericrouach
    @ericrouach 4 роки тому

    great explanation! thanks a lot!

  • @koroslav
    @koroslav 8 років тому

    Thanks for the video. It helped me a lot.

  • @laszloneduka8875
    @laszloneduka8875 3 роки тому +1

    Thank you.....

  • @mohamed-fatta
    @mohamed-fatta 6 років тому

    thank u again i know ur vids are a bit older but still useful

  • @SomebodyOutTh3re
    @SomebodyOutTh3re 6 років тому

    Thank you!

  • @christianrodier3381
    @christianrodier3381 5 років тому

    That was great

  • @Unearthed13
    @Unearthed13 10 років тому +1

    Those poor Star Trek red shirt people :-( ......LOL, great video Andrew, thanks :-)

  • @mcallisterbeacon
    @mcallisterbeacon 9 років тому +3

    'tom cruise as random redshirt' hahaha

  • @nickt423
    @nickt423 5 років тому

    @15:43...So can I think of it like this... If new row that is trying to be inserted DOES HAVE a DateOfDeath in the Actor table then send them the error message.
    If however, the ActorID of the row trying to be inserted does not have a DateOfDeath in the Actor table, then rows get inserted from `tblActor` to the `inserted` table. And then from the `inserted` table they get inserted into the `tblCast` table
    Do I have that right? Is that basically what is going on behind the scenes?

  • @krzysztofmaciak1611
    @krzysztofmaciak1611 8 років тому

    Thx for the video. One question - how could you rollback transaction (15:42) within trigger while none was opened ?

  • @nugan8323
    @nugan8323 11 років тому

    Good Article. Thank you.
    Could you please share knowledge on Locking and Isolation levels in SQL Server

  • @albertma6006
    @albertma6006 11 років тому

    Hi, Your online tutorial is really good, clear and efficient. the only problem is when I try to open your 'Movie' database which I download from your website as .sql file using SQL Server 2012, the queries are completed with errors. The result is that I only get few tables which is far form complete. Do you have any solutions? Thanks.
    Oh, by the way, when I open the movie.sql file , there is a error box saying something like " some bites are replaced with .... saving will not keep the original content" I don't know whether this gives you additional clue.

  • @AnilKumarP4U
    @AnilKumarP4U 11 років тому

    Videos are great.Please share the movie database link. Thanks..

  • @adekupx
    @adekupx 6 років тому

    Hello Andy, thanks fro your these videos, they are really educating. I have an update version of Movie data that was used in this video. i do get an error : The column 'FullName' cannot be modified because is it either a computed column or is the result of a union operator. How do i get around this error message. hope to hear from you soon.

  • @jesusmtz29
    @jesusmtz29 4 роки тому

    Great! Can the BEGIN END include running some python code?

    • @WiseOwlTutorials
      @WiseOwlTutorials  4 роки тому +1

      Hi Jose, you can run Python code using the sp_execute_external_script system stored procedure,. You might find this page useful docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-execute-external-script-transact-sql?view=sql-server-ver15 as it explains the pre-requisites for executing Python in SQL Server, I hope it helps!

  • @kevinike1344
    @kevinike1344 6 років тому

    Can i use both the After and Instead Of triggers at the same time?

  • @krantikumar4048
    @krantikumar4048 6 років тому

    I want to write a query in trigger like: whatever i updated/deleted/inserted in table 1 that updated old data of table 1 should transfer to table 2... how can i write? please help

  • @balajis8279
    @balajis8279 7 років тому

    Hi, your tutorial are really good .I have one doubt in this tutorial
    how we are able to rollback because we never begin transaction anywhere
    pls somone reply thanks in advance

    • @balajis8279
      @balajis8279 7 років тому

      WiseOwlTutorials Thank u thanks a lot keep doing this great stuff

  • @saagarsoni3
    @saagarsoni3 11 років тому

    Sir can u tell us ,HOW to send Email using SSMS ??

    • @saagarsoni3
      @saagarsoni3 11 років тому

      *****
      sir can u please upload a video on this topic,means how to configure email?
      Please..