Unanswered: Update multiple rows/values in one query?
It is my understanding that some databases allow an UPDATE statement that will update multiple rows with different values. Is SQL Server one of them, and if so, what's the syntax?
I have to code a page that displays the (exactly) four items in a database table, where each one has a dropdown widget to allow the user to specify an ordering position. Obviously I can process this in the ASP code by looping through and creating one UPDATE statement per dropdown field, but it seems it'd be easier on the database server if I could do it in one query rather than four. Thanks!