|
Posted by Erland Sommarskog on 11/28/06 22:39
Roy Harvey (roy_harvey@snet.net) writes:
> The other is that the subquery's FROM clause should NOT include the
> table being updated.
And then people keep yelling on the FROM syntax of being dangerous!
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|