ALter table orders add [worthdate] datetime default getdate() update orders set [worthdate]=[edate] ALter table orders add [checkbillno] [int] default 0 update orders set [checkbillno]=0