SQL 2008 R2 - how to update a value ?
Posted on 2012-03-26
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?
Only 3 columnds:
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... ) :)