DELETE FROM Vs_DefaultAccess WHERE (DefaultNo=145) and DefaultType='L' INSERT INTO Vs_DefaultAccess (DefaultName,DefaultNo,DefaultType,DisplayNo,ctype) VALUES('[L145] Force to match actual date vs business date',145,'L',145,'OOXXXXXXXX') DELETE FROM Vs_DefaultAccess WHERE (DefaultNo=146) and DefaultType='L' INSERT INTO Vs_DefaultAccess (DefaultName,DefaultNo,DefaultType,DisplayNo,ctype) VALUES('[L146] Centralize Business Date from Server',146,'L',146,'OOXXXXXXXX') GO ALTER TABLE dbo.Vpos_trs_Bills ADD TaxAmount2 numeric(20, 6) NULL GO ALTER TABLE dbo.Vpos_trs_Bills ADD CONSTRAINT DF_Vpos_trs_Bills_TaxAmount2 DEFAULT 0 FOR TaxAmount2 GO update vpos_trs_bills set taxamount2=taxamount where taxamount2 is null