Editing data in SQL Server 2005
Posted on 2007-08-11
This is a question about the use of SQL server 2005 express.
I notice that when I right click on one of my tables (in the left hand pane), lets say 'users', I am able to "open" it. Here I can see all of my data. If I want to edit one of the fields in this grid that is returned, I can simply select the field, backspace over the old data and enter in my new data. Then if I switch my cursor to another record, the edit I just made is saved.
However, if I do a query (select * from users). The result set I get back will not let me edit any of the fields in the same way I was able to before while just opening the whole table. Instead I need to actually edit the record by issuing an SQL statement.
Is there a way for me to edit the records returned by a SELECT query in the same way I'm able to edit them by opening the entire table.
FYI -- I can certainly write the UPDATE query but in the case of the data I'm dealing with it's much easier to edit the record the 'faster' way.
Thanks very much,