Directly edit query data in MS SQL 2005/2008 Management Studio
In MS SQL 2000 Management Studio it was possible to directly edit data when performing a query by using the “Open Table -> Query” menu option on a table. Microsoft changed things around for SQL 2005/2008, so that menu option is gone, but it can still be done. Here’s how to do it:
An effective way [...]