SSMS Tips and Tricks

Productivity Driven Development

Change Values for Edit Top X and Select Top X Rows Commands

| Comments

When you right click a table inside Object Explorer, you get the options to “Select top 1000 rows” and “Edit top 200 rows”, among other things. If you want to change the number of rows used in these commands, you can do so by going to “Tools->Options->SQL Server Object Explorer->Commands”.

Use SqlSmash to write maintainable SQL scripts, understand code faster and navigate around easily in SSMS.