Updating Column
-
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!
-
Is this a bit column??
Update dbo.Patients Set Billinsurance = 1 where Billinsurance = 0
-
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.
-
Just tried it, and it worked great! Thanks
! -
HTH.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply