IF NOT EXISTS(
   SELECT * 
    FROM syscolumns 
    WHERE id=object_id('T_EXTERNALVOICE') and Name='F_DIR')
BEGIN  
        ALTER TABLE T_EXTERNALVOICE ADD F_DIR VARCHAR(50) 
END
GO

IF NOT EXISTS(
   SELECT * 
    FROM syscolumns 
    WHERE id=object_id('T_MicroPay') and Name='F_CarrierOperator')
BEGIN  
        ALTER TABLE T_MicroPay ADD F_CarrierOperator varchar(20) 
END
go

update T_MicroPay set F_CarrierOperator = 'ShouQianBa' where F_CarrierOperator is null;
go