if not exists(select 0 from syscolumns where id=object_id('KtvAppEnter') and name='Tag') alter table KtvAppenter add Tag nvarchar(500) default('') if not exists(select 0 from syscolumns where id=object_id('KtvAppEnter') and name='Summary') alter table KtvAppenter add Summary nvarchar(500) default('') if not exists(select 0 from syscolumns where id=object_id('KtvAppEnter') and name='BgPic') alter table KtvAppenter add BgPic nvarchar(500) default('') if not exists (select 0 from syscolumns where id=object_id('ktvmodule_submain') and name='sort') ALTER TABLE ktvmodule_submain Add sort int if not exists (select 0 from syscolumns where id=OBJECT_ID('ktvmodule_class') and name='light') alter table ktvmodule_class add light int null