SQL Server Programming Part 16 - DDL Triggers
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
By Andrew Gould
https://www.wiseowl.co.uk - Triggers are special stored procedures that you can attach to various events within a database. This video covers DDL, or Data Definition Language triggers, which you can use to handle events associated with changing the objects in a datatbase. This video concentrates on creating triggers to handle the CREATE, ALTER and DROP events and will show you how to scope a trigger to a single database or to an entire server. You'll also see how to disable and enable triggers, as well as how to change the order in which your triggers fire.
You can see a written version of this tutorial at:
https://www.wiseowl.co.uk/blog/s388/s...
You can download the script to create the Movies database used in this video at the following link:
https://www.wiseowl.co.uk/sundry/movi...
You can see the range of resources and courses we offer in SQL Server here:
https://www.wiseowl.co.uk/sql/
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!
Auf dieser Seite können Sie das Online-Video SQL Server Programming Part 16 - DDL Triggers mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer WiseOwlTutorials 27 November 2013 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 61,309 Mal angesehen und es wurde von 304 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
