• Rob Fisk (1/30/2011)


    SELECT m.*

    --UPDATE m SET monkey = 'marmosette'

    FROM monkeys m

    WHERE MonkyID=2

    That's the same way I always write updates/deletes. It is not perfect, but it is safer.

    By the way it is interesting, that this type of syntax works well in mssql, but doesn't in other Sql dialects. Aliases after Update/Delete words seems to not be sql 92 standard.