alter table vpos_eod_bills add OnlineSyncBB bit default 0 null
go
alter table vpos_eod_billdetails add OnlineSyncBB bit default 0 null
go
alter table vpos_eod_generaldetails add OnlineSyncBB bit default 0 null
go

update vpos_eod_bills set OnlineSyncBB=0 Where OnlineSyncBB is null
go
update vpos_eod_billdetails set OnlineSyncBB=0 Where OnlineSyncBB is null
go
update vpos_eod_generaldetails set OnlineSyncBB=0 Where OnlineSyncBB is null
go