Solved

SQL 2008 R2 - how to update a value ?

Posted on 2012-03-26
2
287 Views
Last Modified: 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?
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... ) :)
0
Comment
Question by:xcomiii
2 Comments
 
LVL 7

Accepted Solution

by:
peea earned 500 total points
ID: 37765593
> 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
 
LVL 5

Expert Comment

by:Ronak Patel
ID: 37765605
here is the query syntax for update value in data table:


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

Open in new window

0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now