Sql Edit Top 1000. The field that has the close date is closedat and the values are formatted as a date and a time. The disadvantage of using the open table option of sql server 2005 management studio was that ssms used to hang or become unresponsive for a long period of time if you happened to open a large table.
Right click anywhere on the results and hover your pointer over pane. Value for select toprows command to a value greater than or less than 1000. In sql server 2008 management studio by default you can only select top 1000 rows or edit top 200 rows for a table as shown in the below snippet.
Click on tools in the menu and then options.
The sql select top clause. To do this in ssms navigate to tools options sql server object explorer commands and then edit the value for value for select top n. Right click on the top left corner of the. To modify the select top 1000 rows or edit top 200 rows settings do the following.