Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL edit Query

Posted on 2008-06-25
1
Medium Priority
?
187 Views
Last Modified: 2010-03-19
When I run a query in SQl Management Studio I cant edit any of the records in the result.  If I want to edit one of the rows I have to find the ID number, open up the full table and then edit the row.  This can be very tedious.  Is there a way to edit queries.
0
Comment
Question by:Kevin Robinson
1 Comment
 
LVL 32

Accepted Solution

by:
Daniel Wilson earned 2000 total points
ID: 21865270
You can open the table, then show the SQL and modify it to your query.

Adding elements to the WHERE clause, this works fine.  Doing a JOIN in your query, I don't think it will work.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
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…
Integration Management Part 2
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…

886 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