SQL Server Programming Part 15 - DML Triggers

Поділитися
Вставка
  • Опубліковано 15 гру 2024

КОМЕНТАРІ • 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

  • @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...

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

    This man is an actual legend

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

    EXCELLENT AS USUAL Andrew!!
    Thanks a lot

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

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

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

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

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

    Good work! Keep it up.

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

    Thank you this really helps me prepare for my exam!

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

    @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?

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

    great explanation! thanks a lot!

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

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

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

    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.

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

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

  • @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.

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

    Thanks for the video. It helped me a lot.

  • @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

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

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

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

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

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

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

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

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

    • @WiseOwlTutorials
      @WiseOwlTutorials  3 роки тому +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!

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

    'tom cruise as random redshirt' hahaha

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

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

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

    Thank you.....

  • @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

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

    Thank you!

  • @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..

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

    That was great