How to delete the top 1000 rows from a table using Sql Server 2008?

by

The code you tried is in fact two statements. A DELETE followed by a SELECT.

You don’t define TOP as ordered by what.

For a specific ordering criteria deleting from a CTE or similar table expression is the most efficient way.

;WITH CTE AS
(
SELECT TOP 1000 *
FROM [mytab]
ORDER BY a1
)
DELETE FROM CTE

More Related Contents:

  1. How can I delete using INNER JOIN with SQL Server?
  2. Get the mentioned output by SQL query
  3. Sql Mathematical calculations [closed]
  4. I need help formatting inner join command in SQL query
  5. Calculate a Running Total in SQL Server
  6. LIMIT 10..20 in SQL Server
  7. SQL transpose full table
  8. How to Create a real one-to-one relationship in SQL Server
  9. Select statement to find duplicates on certain fields
  10. Getting only Month and Year from SQL DATE
  11. How to fetch the row count for all tables in a SQL SERVER database [duplicate]
  12. WHERE Clause vs ON when using JOIN
  13. Using a Variable in OPENROWSET Query
  14. @@IDENTITY, SCOPE_IDENTITY(), OUTPUT and other methods of retrieving last identity
  15. Does MS SQL Server’s “between” include the range boundaries?
  16. Check for file exists or not in sql server?
  17. How to get the first and last date of the current year?
  18. Split one column value into multiple column values
  19. SQL Server PIVOT perhaps?
  20. “Order By” using a parameter for the column name
  21. DISTINCT for only one column
  22. Measuring Query Performance : “Execution Plan Query Cost” vs “Time Taken”
  23. How do I create and query linked database servers in SQL Server?
  24. Add emoji / emoticon to SQL Server table
  25. Perform regex (replace) in an SQL query
  26. What is the internal representation of datetime in sql server?
  27. Eliminate and reduce overlapping date ranges
  28. SQL Server 2005 – Export table programmatically (run a .sql file to rebuild it)
  29. What’s the correct name for an “association table” (a many-to-many relationship) [closed]
  30. Convert bigint to datetime

Leave a Comment