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

 

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

i totally agree with you that MS SQL is one of the best DBMS and its not that hard to understand or study its tool. you just have to oncentrate,

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

My sql server is really a powerful and helpful software...

I want to know about the working of query analyzer.If you have knowledge about that then please help me.

I am not very familiar with MySQL but when it comes to MySQL i can help you much quicker

The query is:-
update into table name student Amon which roll no=5;

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..

I don't know how big the place is you work at, but our shop gets audited all the time. Auditors get real cranky when they come across database updates without an audit trail of some type.

[Guest]

[62.885]

Googlebot, nathan.joshua, Yahoo crawler