altersectiontableaddfailoverskincolumn.sql

ASP开发网站的 关于网站的设计和说明 还有SQL的程序 数据库

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