Re: update multiple columns

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jason (jasonlewis_at_hotrmail.com)
Date: 12/03/04 

Date: Fri, 3 Dec 2004 11:51:18 +0100

"Robert Davis" <RobertDavis@discussions.microsoft.com> wrote in message
news:10822553-DFC5-4457-BD8B-A5838B634B04@microsoft.com...
> Build your update query dynamically by querying the
> information_schema.columns view (you can't see it in the database, but
it's
> there).
>
> Robert.
>
> "Jason" wrote:
>
> > Hi,
> >
> > Somebody knows a way to update multiple columns without typing each
column?
> >
> > I'm cleaning up a database where i have one table that shouldn't have
double
> > records. The thing is, that those records should be merged into 1
record.
> >
> > I would like to do something where the value is null in one of those
records
> > and replace that with the value of one the records. There are like 250
> > columns and there should be a way to do it like insert statement.
> >
> > Greetings,
> >
> > J
> >
> >
> >

Hi Robert,

Could you give me an example? I have some trouble with my sql skills.

Relevant Pages

  • Re: OOP/OOD Philosophy
    ... >From where I sit, as an observer to this conversation, Robert made his ... It is not only quite possible for a change in the database to crash ... No one said that you would isolate the change in the persistence layer. ...
    (comp.object)
  • Re: Breaking into a running app?
    ... Great idea, Robert! ... then, if a user reports problems, I can go back and look at ... creating a installation package may solve your ... > database... ...
    (microsoft.public.vb.general.discussion)
  • Re: PHP, MySQL and UTF-8?
    ... On 9/12/2011 12:46 PM, Robert Latest wrote: ... I have UTF-8 characters in my database. ... how do I retrieve UTF-8 chars from a database? ...
    (comp.lang.php)
  • Re: Need assistance with hash of arrays and injecting values
    ... Hi Robert, I'll have to mull over everything you just posted. ... I would like to clean up a lot of my date code. ... The dates in the database were simply YYYY-MM-DD ...
    (comp.lang.ruby)
  • Re: Connecting to a database
    ... Robert, Visual Basic is fundamentally different to Access. ... program to the actual database management program, MS Jet. ... Your database is a Jet database, ...
    (microsoft.public.access.formscoding)