Post reply

Updating Column

  • July 15, 2005 at 9:48 am

    #363121

    Sorry if this question is so simple, but I am very new to SQL server. But hopefully someone can help a newbie out .

    I just wanted to update a column in a table. All the values are set to false (or 0) in a updated version. And I wanted to change all the values to True (or 1).

    So I tried this:

    Where the table is called patients and the column is called billinsurance.

    Update Patients

    Set Billinsurance = True

     

    TIA!

     

  • July 15, 2005 at 9:53 am

    #574920

    Is this a bit column??

    Update dbo.Patients Set Billinsurance = 1 where Billinsurance = 0

  • July 15, 2005 at 10:27 am

    #574949

    It is indeed a bit column. Thanks for the response, I am more familiar with Oracle SQL, and know nothing about SQL server. Hard to explain for me, as I am a newbie, but the differences are subtle, yet dramatic.

    I'll try this out.

  • July 15, 2005 at 10:32 am

    #574953

    Just tried it, and it worked great! Thanks !

  • July 15, 2005 at 7:22 pm

    #575079

    HTH.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply