Ask the Expert

Update two columns with one UPDATE command

How to update two columns in a table with one update command?

    Requires Free Membership to View

We've been getting a number of questions like this recently. On the surface they seem simple. After digging into them for a while, they still seem simple.

Do all of you have a copy of your SQL Reference manual? Every major database system, whether proprietary or open source, has a manual which you can browse for free on the Web.

update daTable
   set Column1 = 9
     , Column2 = 37
 where Foo = 'Bar'

That wasn't so hard, was it.

This was first published in April 2007

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: