IF EXISTS(
   SELECT * 
    FROM syscolumns 
    WHERE id=object_id('T_PROMOTION') and Name='F_CARDTYPEID')
BEGIN   
   ALTER TABLE T_PROMOTION alter COLUMN F_CARDTYPEID varchar(6000)
END
GO
--本地和远程均需执行
-- 执行后替换120.1522的最新程序