• 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/