Editing Data from SSMS

Rate This
  • Comments 2

Sometimes you want to edit data directly in a table (often a very bad idea!). In Enterprise Manager (SQL2K) and SQL Server Management Studio (SQL2K5) you right-click a table and select "Open Table" from the menu. That brings back ALL of the rows in the table, and you edit them that way. This has a bad habit of locking tables while all that happens.

So in SSMS 2K8, we added two menu items - "Edit Top 200 Rows" and "Select Top 1000 Rows". Now you can edit just a few at a time or view them. By the way, these numbers are a value you can set in the Tools | Options menu.

Leave a Comment
  • Please add 6 and 6 and type the answer here:
  • Post
Page 1 of 1 (2 items)