Microsoft KB Archive/325239

= Support WebCast: Understanding INSTEAD OF Triggers in Microsoft SQL Server 2000 =

Article ID: 325239

Article Last Modified on 6/22/2004

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q325239





Session Summary
During this presentation, we will talk about one of the new features introduced in Microsoft SQL Server 2000, INSTEAD OF triggers. In SQL Server version 7.0 and earlier, triggers are implemented in a before fashion. In other words, any constraint checks are performed after the insert is attempted. The INSTEAD OF trigger functionality performs the actions specified in the definition of the trigger. We will also discuss, and provide examples of, some of the main applications of INSTEAD OF triggers, including implementing cascading referential integrity and inheritance. We will talk about performance of INSTEAD OF triggers and metadata considerations. Finally, we will explain some of the restrictions and caveats to heed when using this feature.

This is a Level 200 session that was recorded Tuesday, January 16, 2001: 10:00 A.M. Pacific time (Greenwich mean time - 8 hours) and presented by Dinesh Murthy. Dinesh Murthy works as a developer support professional in the SQL Server Database Development team. His primary responsibilities include database performance tuning and concurrency control in high-end SQL Server systems implemented around the globe. Dinesh has a Master's degree in Computer Science.

Viewing the Presentation
To view, please click on the link: [javascript:fnViewMMC('http://support.microsoft.com/servicedesks/webcasts/seminar/shared/asp/view.asp?url=/servicedesks/webcasts/en/wc011601/manifest.xml'); View this Support Webcast] (Length: 1 hour 15 minutes)



This Windows Streaming Media archive requires an Internet connection of 28.8 Kbps or faster, and is best viewed with a minimum screen resolution of 800 X 600.

Additional Resources
Download presentation wc011601. This is a 256-KB Microsoft PowerPoint (.ppt) file.

If you do not have PowerPoint and you want a copy of the slides, use the PowerPoint Viewer (2,752 KB).

Read the transcript from this Support WebCast

[mailto:?subject=Support%20WebCast:%20Understanding%20INSTEAD%20OF%20Triggers%20in%20Microsoft%20SQL%20Server%202000&body=Take%20a%20look%20at%20this%20Microsoft%20Support%20WebCast%20about%20Understanding%20INSTEAD%20OF%20Triggers%20in%20Microsoft%20SQL%20Server%202000%20(Tuesday,%20January%2016,%202001:%2010:00%20A.M.%20Pacific%20time%20(Greenwich%20mean%20time%20-%208%20hours)).%20More%20information%20about%20this%20WebCast%20is%20available%20at%20http://support.microsoft.com/WebCasts. Tell a friend about this Support WebCast]

Provide Feedback on this Broadcast

Support WebCasts Home

Keywords: kbinfo kbdownload kbtshoot kbwebcastsupport KB325239

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.