Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


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

Posted on 2007-10-01
Medium Priority
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

ID: 19993420
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

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

Expert Comment

ID: 19993647
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

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

Accepted Solution

MrRobot earned 500 total points
ID: 19993745
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

580 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