How to modify a row of values at the same time

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

How to modify a row of values at the same time

Author

Topic

cajunzx6
Starting Member

1 Post

Posted - 2009-08-28 : 16:59:53

I'm pretty much new to SQL but I have a task at hand that needs to be completed by COB on Sunday Aug 30th.

We have a program called AIM which is SQL based database, there is about 1000 or so values that need to be changed either by hand one by one or at the same time in SQL.

is there a query that I can run in SQL to find the entries and to modify them?

norb

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-08-29 : 11:19:21

Yes. You can use an UPDATE query to change the value of the required records all at the same time.

the syntax will be something like


UPDATE SOMETABLE
SET    SOMECOL = somevalue
WHERE  SOMEOTHERCOL = someothervalue

KH
[spoiler]Time is always against us[/spoiler]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources