SQL TIP: Auto Increment in an UPDATE statement.
Assigning Update Values Using Subqueries
A CROSS JOIN clause is automatically inserted into an UPDATE statement that uses an INNER JOIN clause when you execute the statement in the SQL pane of SQL Server Management Studio
Visual Studio 2005 Service Pack 1 Update for Windows Vista
To find out more, including how to control cookies, see here: