SqlTrigger attribute

Wednesday, October 20, 2004

<SqlTrigger(Name:="trtblSearchResults", Target:="tblSearchResults", Event:="FOR INSERT, UPDATE")>

With Sql Server 2005 and Visual Studio .NET 2005 (Whidbey), you will be able to define the table that you wish to apply the trigger to, the name of the trigger, and the Events that you want the trigger to monitor. When you deploy the trigger through Visual Studio .NET to Sql Server 2005, Visual Studio and Sql Server will wire the trigger to the events.

Wally

4 Comments

While I understand the underlying need for the FOR keyword, I don't quite agree with it being necessary for the Event property of the attribute. Just seems like it's an implementation detail that should be implicit.

Drew Marsh - Wednesday, October 20, 2004 1:40:00 PM

Oh my gosh, somebody that reads something I say! :-)

Wallym - Wednesday, October 20, 2004 1:43:00 PM

This is SQL man, it's all strings.

Scott Swigart - Wednesday, October 20, 2004 2:28:00 PM

No, this is the CLR being hosted in SQL so it should be typed according to the CLR, not SQL. Guess that's what happens when you get SQL people trying to design CLR classes, but someone who is more clear centric should be reviewing these classes.

Drew Marsh - Thursday, October 21, 2004 12:16:00 AM

Comments have been disabled for this content.