Solved

SQL 2008 R2 - how to update a value ?

Posted on 2012-03-26
2
294 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Suggested Solutions

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

710 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