How to alter SQL in “Edit Top 200 Rows” in SQL Server Management Studio 2008

Right click the results for your “Edit Top 200 Rows” query in SQL Server Management Studio 2008 and you will see the menu context option “Pane -> SQL”. This shows the SQL that was executed which you can then edit as you see fit.

Advertisements