Select and Edit all rows in SQL Server Management Studio

sqlserver select all rows

If you use SQL Server Management Studio often, you will have noticed that from the context menu that is displayed when right clicking on a table, there are two options (among the others) namely Select Top 1000 Rows and Edit Top 200 Rows. Looking for something else? Try these links instead: Script