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.