Questions specific to a country should not be presented. I'm sure the American audience wouldn't like UK, China, etc related questions. This is topped by allocating 7 points...

SELECT

*

FROM

HumanResources.Employee

WHERE

Title IN (SELECT TOP 3 Title FROM HumanResources.Employee)

Your answer is wrong. You do not need to specify an order by when TOP is used. Who vets these...

I agree.

In reflection the statement can be read in more than one way. Hence should not have been written in a way that prevents confusion.

I had read this. Hence my earlier statement as the question clearly states "any UPDATE statement". So singling out individuals does not apply.

USE AdventureWorks;

BEGIN TRAN

UPDATE TOP (10) Sales.Store

SET SalesPersonID =...

Firstly you have not qualified the version of SQL server the question is for hence one assumes SS2005.

BOL states:

UPDATE

[ TOP ( expression ) [ PERCENT...

-- there may be loss of formatting

-- I've used 4 sapce tab

-- firstly I don't like loops but do prefer them over cursors

-- for data movement set based solutions are...

have you read BOL comments before using auto_fix? It would have been nice if you had mentioned the need for caution as per BOL.

/*

Why are you using temp table and using subquery? A subquery is not as efficient as a join or a derived table or an exists. The latter being...