UPDATE VS4TInventoryLOT Set TIMCVATTYpe=0 WHERE TIMCVATTYpe is null
GO
UPDATE VS4TInventoryLOT Set TIMCVATRate=7 WHERE TIMCVATRate is null
GO
UPDATE VS4TInventoryLOT Set TIMCVATAmount=0 WHERE TIMCVATAmount is null
GO
UPDATE VS4TInventoryLOT Set TIMCDiscountText='' WHERE TIMCDiscountText is null
GO
UPDATE VS4TInventoryLOT Set TIMCDiscountTotal=0 WHERE TIMCDiscountTotal is null
GO