"Updated" keyword in trigger

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » "Updated" keyword in trigger

"Updated" keyword in trigger

Rate Topic

Display Mode

Topic Options

Author

Message

tripower

Posted Monday, December 07, 2009 5:27 AM

Valued Member

Group: General Forum Members
Last Login: Thursday, May 17, 2012 5:39 AM
Points: 61, Visits: 123

Is there not an updated keyword for triggers, as in:
select * from updated

And if not how would I do this?

Post #829761

Adi Cohn-120898

Posted Monday, December 07, 2009 5:42 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 9:50 AM
Points: 2,019, Visits: 4,923

There is no updated view. You can work with inserted and deleted view or with the update() function. You can read about it in BOL (Books On Line the help that is installed with SQL Server’s client tools)

Adi

--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #829768

« Prev Topic | Next Topic »

Permissions