Thinker

Personal e-notepad


    ----Patch command-----

    Aueeins
    Aueeins
    水面上的小草

    帖子数 : 173
    积分 : 3430
    威望 : 0
    注册日期 : 2011-09-08
    地点 : SG

    ----Patch command----- Empty ----Patch command-----

    Post by Aueeins on 14/11/11, 07:37 am

    IF Not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'm10SoftwareTask' AND COLUMN_NAME ='Others1') begin alter table m10SoftwareTask add Others1 bit end

      Current date/time is 17/02/20, 11:05 am