SQL query program to edit records

I have a need for a program better than Query Analyzer, I use Enterprise Manager on a daily basis for work purposes and have given the Query Analyzer program to our head person in charge of the front-end of the software, but they are now having a growing need to edit bulk things and with a SELECT statement in Query Analyzer you then have to go back and do update statements to update specific fields. With Enterprise Manager you can click in the box and change the values on the fly. Now as much as this scares me I dont want to give them Enterprise Manager just because of its sheer power, but I want them to have a similar program to be able to edit the fields right in front of them (easier) and just have to write a select statement..

Any suggestions

[Join us @ facebook]

What DBMS you are using?

Correct me if I'm wrong it seems that your using a Microsoft SQL Server. Seens there is the Enterprise Manager though I'm not yet so expert of the Software but I think SQL Server has a tool that would allow them to search for a particular row in the database, I'm actually an avid user of MySql and they had a GUI query analyzer and it does even have a tool that would help me to search for the row on which I would intentionally need to update the informations thats why MS SQL Server might still have the same service, but if it might be too complicated for them to type the SELECT statement just to search, or a too burden for them typing the whole UPDATE statement it might just be better if you develop a some kind of application that may solve the problem. As far as I'm concern MS SQL Server is one of the best DBMS available in the market

[Guest]

[44.193]

Yahoo crawler, Msnbot, adsense, Baidu Spider