SQL 2008 R2 - how to update a value ?

Hi, I am total newbie in SQL statements, and need some help in updating some values.

As I understand, SQL 2008 R2 does not have any GUI it self to update or change values. You need to create T-SQL statements/queries.

I have found some commercial web-based applications, but they are pretty expensive and I just need to change 3 simple values in 3 different tables. Going to hard way and learn T-SQL from the beginning, is not an option, I simply have no time for it.

Can anyone give me a simple example of a query that updates the value a table?
For example:
db_name: TestDB

Only 3 columnds:
Id
Member Name
Member value

I need to change a value in the Member Value column WHERE Id=101 from (just an example) 20 to 10.

Or if there exists an option to edit it directly, would be even better (I am getting too lazy after using phpMyAdmin for some years now... ) :)
LVL 9
xcomiiiAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

peeaCommented:
> As I understand, SQL 2008 R2 does not have any GUI it self to update or change values. You need to create T-SQL statements/queries.

You may actually edit some values under SQL Server Management Studio directly, as shown below with my SQL Server 2005.

SQL Server Management Studio to edit opened table
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ronak PatelCommented:
here is the query syntax for update value in data table:


UPDATE [TableName]
SET  MemberValue = '10'
WHERE Id = 101

Open in new window

0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.