SQL Server Management Studio (Express) how to make grid which results from SELECT query updateable?

Hello,
When using SQL Server 2005 Express Management Studio I am able to update rows displayed in the grid when I use "Open" to view the contents of a table but not when I run a query such as "SELECT * FROM MyTable WHERE MyColumn='ABC'". Is there a way to enable direct updating to the query result grid?
A work-around I've found is to click on the SQL button on the toolbar after opening the table and add a WHERE clause but I'd rather just get updatable result.
pdegregorioAsked:
Who is Participating?
 
MrRobotCommented:
create an empty table, name it to make it the first or the last in the list for easy access, like 'aaa' or something.

open the table when you want to get a result from a query, click the sql button to open the sql pane, change the sql code to your query, refresh to get your query results, now you can easily edit your resultset.

shame on ms not containing this as a standard function.

rob
0
 
YveauCommented:
I don't think the result pane is meant for that and I'm pretty sure what you want is not possible ...

Hope this helps ...
0
 
ptjcbCommented:
I'm sorry, but the query result set is static. You cannot edit it.
0
 
SwindleCommented:
When you click "open table" to view the contents of the table, it will load every single row in the table.  It won't let you edit them until the contents of the table are 100% loaded.  Make sure it's not still "load row x of x" down in the bottom left corner.
0
 
SwindleCommented:
oh my...I completely misread that...yeah the other guys are right.  You can't edit the results of a query.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.