THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Best Practices » SQL Server 2005 » T-SQL   (RSS)
Sorry, but there are no more tags available to filter with.
  • Nondeterministic UPDATE

    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 a FROM clause that is not specified in such a way that only one value is available for ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on November 13, 2007
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement