Customizing "Edit Top 200 Rows" in SQL Server Management Studio

It is a very common requirement that, sometimes we want to change the edit top 200 rows query. This is very much possible and easy in SQL Server Management Studio.
  1. Right click on table and select "Edit Top 200 Rows"
  2. Press "Ctrl + 3" on rows in edit mode window
  3. Now you can see the query which returned 200 rows allowing you to edit
  4. On this query window, right click to execute the query on window itself
And voila, you have records based on your query to edit those on window :)

Hope this helps.

Comments

Popular posts from this blog