April 23, 2012

How to edit selected rows manually in SQL Server Mangament Studio

Right-click on any specific table in SQL Sever object explorer, gives you the option Edit top 200 rows, and displays the top 200 rows in grid format, where you can edit values manually. But the problem arises when you want to edit rows in this way, but need rows of your choice, not top 200. You need the rows e.g. based on where clause filter expressions.

To obtain this behavior, you need the following steps :
  1. Right-click on any table
  2. Click Edit top 200 rows
  3. Right-click on any cell of the rows (displaying in the result pane)
  4. Goto Pane > SQL
  5. Now you can use where clause with filter expressions and you required and get the results in grid form which you can edit manually.

No comments:

Post a Comment