SQL Server Update records

I am working with SQL Server 2000 (connecting with SSMS 2008).
In SSMS if I click on Open Table (or Open x # of Records) I can then edit the records that are displayed.  If I run a Select Query and then view the results set.  Is there a method where I can have the results displayed in edit mode?  I want to be able to edit the records manually that are returned from a select statement without having to do this with an update query.   I have no issue doing this with an update query, but someone else was asking me if their is a way to do this.  Thanks.
LVL 3
fjkaykr11Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Kevin CrossConnect With a Mentor Chief Technology OfficerCommented:
Yes, it is possible. When you right click and select Open Table, the Show SQL Pane option is available as one of the icons. If you edit the SQL to the SELECT statement you want, the results are still editable (I have only ever tried with simple filters). Works on my SQL Server 2005 and 2012 standard SSMS.
0
 
SharathData EngineerCommented:
No way in SSMS. You need to write UPDATE statement for your SELECT statement. Or you have to update the records the way you are updating from the right click menu option.
0
 
fjkaykr11Author Commented:
thanks for the info. I didn't think there was a way to do this I just was just checking.
0
 
fjkaykr11Author Commented:
Thanks for the info.  I think that is what I need.
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.