Under the description for UPDATE in SQL Server 2000 and 2005 Books Online, you can find the following statement (thanks to SQL Server MVP Steve Kass for pointing me to this passage): The results of an UPDATE statement are undefined if the statement includes
Read More...