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.


Popular posts from this blog

Migrating database from ASP.NET Identity to ASP.NET Core Identity

Customize User's Profile in ASP.NET Identity System

Lambda two tables and three tables inner join code samples