• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 59
  • Last Modified:

T-SQL Edit Top 5000 Rows - Query?

Once in a while, I need to make a few modifications on a handful of records... I'd prefer to SEE the records, by using the Edit Top 5000 Rows, however I only need to see 5-10. Is there a way to write a query that will display 5-10 records that will also allow me to edit?

Thanks,

E.D.
0
Frank Grimes
Asked:
Frank Grimes
1 Solution
 
Éric MoreauSenior .Net ConsultantCommented:
the top 5000 you are referring to can be adjusted (the default is actually 200). Check this image captured from SSMS 2016:
setting the number of rows to edit
Also, once the original query has been executed, you can use the "Show SQL Pane" button to change the number from the TOP (xxx) clause to the value you want.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now