how can I Update top 100 records in sql server

by

Note, the parentheses are required for UPDATE statements:

update top (100) table1 set field1 = 1

More Related Contents:

  1. How can I do an UPDATE statement with JOIN in SQL Server?
  2. SQL update query using joins
  3. How to update and order by using ms sql
  4. I want to use CASE statement to update some records in sql server 2005
  5. Update query using Subquery in Sql Server
  6. Convert text to system date format [duplicate]
  7. How to get a particular preceding value of a column in SQL [closed]
  8. Simple way to transpose columns and rows in SQL?
  9. SQL update from one Table to another based on a ID match
  10. Only inserting a row if it’s not already there
  11. Maximum size for a SQL Server Query? IN clause? Is there a Better Approach [duplicate]
  12. SQL JOIN vs IN performance?
  13. Most efficient way in SQL Server to get date from date+time?
  14. Convert varchar into datetime in SQL Server
  15. TSQL Pivot without aggregate function
  16. How to generate a range of dates in SQL Server
  17. SQL RANK() versus ROW_NUMBER()
  18. Check if a row exists, otherwise insert
  19. Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql statement
  20. How do I create a foreign key in SQL Server?
  21. How do I group on continuous ranges
  22. join comma delimited data column
  23. Is it possible to perform multiple updates with a single UPDATE SQL statement?
  24. Incorrect syntax near the keyword ‘with’…previous statement must be terminated with a semicolon
  25. Alter user defined type in SQL Server
  26. Store multiple bit values in a single table column
  27. SQL Server equivalent to MySQL enum data type?
  28. SQL – Call Stored Procedure for each record
  29. COALESCE Function in TSQL
  30. Convert bigint to datetime

Leave a Comment