altersectiontableaddfailoverskincolumn.sql

来自「非常不错的学校在线考试分析系统」· SQL 代码 · 共 20 行

ALTER TABLE dbo.Community_Sections
ADD section_failOverPageSkin NVARCHAR(100) NULL
go
update dbo.Community_Sections
set section_failOverPageSkin = ''
go
update dbo.Community_Sections
set section_failOverPageSkin = section_pageSkin
where section_parentID = -1
go
ALTER TABLE dbo.Community_SampleSections
ADD section_failOverPageSkin NVARCHAR(100) NULL
go
update dbo.Community_SampleSections
set section_failOverPageSkin = ''
go
update dbo.Community_SampleSections
set section_failOverPageSkin = section_pageSkin
where section_parentID = -1
go