SQL Server Programming Part 16 - DDL Triggers

Pubblicato il: 27 novembre 2013
sul canale di: WiseOwlTutorials

61,309

304

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!

In questa pagina del sito puoi guardare il video online SQL Server Programming Part 16 - DDL Triggers della durata di ore minuti seconda in buona qualità , che l'utente ha caricato WiseOwlTutorials 27 novembre 2013, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 61,309 volte e gli è piaciuto 304 spettatori. Buona visione!

216