Editing data easier with SQL Server 2005
Posted on 2007-12-03
I am new to SQL Server 2005 (and SQL in general)
I mainly used MS Access databases in the past.
Using Access to edit, look at and sort data is extremely easy.
With SQL Server, I find it almost impossible.
The only tool I have right now is SQL Server Management Studio
I can't seem to sort properly, on any fields (if at all), I cannot easily edit one field.
There are many jobs I used to do with Access that are no longer practical in SQL Server.
With SQL server, I have to write code to do the easy stuff.
So my question is:
Is there a third party interface to SQL server data that makes it as easy to massage the data?
Something that will alow me to edit column by column or field by field, searchable sortable and as "friendly" as Access?
I am really looking for people who know what I am talking about and have a program they use (or used) in mind. I am not looking for just a general link to a third party app (I can get that on google), so if you haven't at least tried it, please don't respond.