altersectiontableaddfailoverskincolumn.sql

ASP.NET精品全站程序SQL版.rar

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