UPDATE T25M001.DBO.BILL_DETAIL SET DispFromAdd1='' WHERE DispFromAdd1 IS NULL UPDATE T25M001.DBO.BILL_DETAIL SET DispFromAdd2='' WHERE DispFromAdd2 IS NULL alter table T26S002.dbo.SCREEN_ITEM_MASTER add ItemPer Varchar(1)
UPDATE T25M001.DBO.BILL_DETAIL SET DispFromAdd1='' WHERE DispFromAdd1 IS NULL UPDATE T25M001.DBO.BILL_DETAIL SET DispFromAdd2='' WHERE DispFromAdd2 IS NULL alter table T26S002.dbo.SCREEN_ITEM_MASTER add ItemPer Varchar(1)