Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

"Updated" keyword in trigger Expand / Collapse
Author
Message
Posted Monday, December 7, 2009 5:27 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued 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
Posted Monday, December 7, 2009 5:42 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 4:19 AM
Points: 2,115, Visits: 5,430
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 »

Add to briefcase

Permissions Expand / Collapse