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 » t-sql » T-SQL language ... » Connect   (RSS)
  • DELETE FROM Where?

    For years, SQL Server has supported a (second) FROM clause in UPDATE and DELETE statements. Its behavior isn't always deterministic, a fact Microsoft points out in the documentation. Today, someone was surprised by the basic semantics of DELETE .. FROM. This probably happens a lot, but fortunately today's surprisee posted this ...
    Posted to Steve Kass (Weblog) by skass on April 30, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement