How to update and order by using ms sql

by 
WITH    q AS
        (
        SELECT  TOP 10 *
        FROM    messages
        WHERE   status = 0
        ORDER BY
                priority DESC
        )
UPDATE  q
SET     status = 10

More Related Contents:

  1. How can I do an UPDATE statement with JOIN in SQL Server?
  2. SQL update query using joins
  3. When no ‘Order by’ is specified, what order does a query choose for your record set?
  4. how can I Update top 100 records in sql server
  5. I want to use CASE statement to update some records in sql server 2005
  6. Update query using Subquery in Sql Server
  7. how does SELECT TOP works when no order by is specified?
  8. SQL where clause odd behavior [closed]
  9. How do I obtain a Query Execution Plan in SQL Server?
  10. How do I escape a single quote in SQL Server?
  11. Only inserting a row if it’s not already there
  12. Unpivot with column name
  13. Selecting data from two different servers in SQL Server
  14. Most efficient way in SQL Server to get date from date+time?
  15. Generate SQL Create Scripts for existing tables with Query
  16. How to rewrite IS DISTINCT FROM and IS NOT DISTINCT FROM in SQL Server 20008R2?
  17. How do I delete from multiple tables using INNER JOIN in SQL server
  18. SQL : BETWEEN vs =
  19. How do I perform a GROUP BY on an aliased column in SQL Server?
  20. Need to list all triggers in SQL Server database with table name and table’s schema
  21. Count based on condition in SQL Server
  22. Is it possible to perform multiple updates with a single UPDATE SQL statement?
  23. Best equivalent for IsInteger in SQL Server
  24. Syntax of for-loop in SQL Server
  25. How to correctly insert newline in nvarchar [duplicate]
  26. How do you copy a record in a SQL table but swap out the unique id of the new row?
  27. Using IF ELSE statement based on Count to execute different Insert statements
  28. Sql Server : How to use an aggregate function like MAX in a WHERE clause
  29. Date serial in SQL?
  30. SQL Server: +(unary) operator on non-numeric Strings

Leave a Comment