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

Posted on 2007-10-01
Last Modified: 2012-05-05
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.
Question by:pdegregorio
    LVL 18

    Expert Comment

    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 ...
    LVL 27

    Expert Comment

    I'm sorry, but the query result set is static. You cannot edit it.
    LVL 11

    Expert Comment

    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.
    LVL 11

    Expert Comment

    oh my...I completely misread that...yeah the other guys are right.  You can't edit the results of a query.
    LVL 8

    Accepted Solution

    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.


    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
    In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now