Link to home
Create AccountLog in
Avatar of Star Gazr1
Star Gazr1Flag for United States of America

asked on

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.
Avatar of Sharath S
Sharath S
Flag of United States of America image

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.
Avatar of Star Gazr1

ASKER

thanks for the info. I didn't think there was a way to do this I just was just checking.
ASKER CERTIFIED SOLUTION
Avatar of Kevin Cross
Kevin Cross
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Thanks for the info.  I think that is what I need.