tripower
SSCrazy
Points: 2035
More actions
December 7, 2009 at 5:27 am
#140441
Is there not an updated keyword for triggers, as in:
select * from updated
And if not how would I do this?
Adi Cohn-120898
SSC-Dedicated
Points: 33944
December 7, 2009 at 5:42 am
#1088455
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/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply