Thursday, 25 November 2010

SQL Server Management Studio - Edit Query Results

This is a useful way to edit results of queries in SQL Server Management Studio 2005 and 2008.

SQL Server 2005
1. Right click table
2. Open Table
3. Right click anywhere in the results > Pane > SQL
4. SQL query windows pops up, enter query here.

SQL Server 2008
1. Right click table
2. Edit Top 200 Rows
3. Right click anywhere in the results > Pane > SQL
4. SQL query windows pops up, enter query here.

2 comments:

net said...

Server Management is essential for a business that have Windows or Linux servers that need to be running at all times because your staff relies on them. There are many different types of servers which include file servers, back up servers, application servers, database, and more.

sandymr24 said...

Is there a way to save this editable query, so I don't have to restructure my queries everytime I need to use them. I need to create several editable canned queries.