--HO分表后批量修改Report_Objects中的表名为视图名，不推荐此方法，应该根据报表具体用途选择使用表或者视图
select * into Report_Objects_bak1 from Report_Objects --备份报表
--加空格替换
update Report_Objects set Config=replace(cast(Config as varchar(8000)),'VAJ1 ','V_VAJ_FULL ') where  datalength(Config)<8000
update Report_Objects set Config=replace(cast(Config as varchar(8000)),'VAK1 ','V_VAK_FULL ') where  datalength(Config)<8000
update Report_Objects set Config=replace(cast(Config as varchar(8000)),'VAI1 ','V_VAI_FULL ') where  datalength(Config)<8000
update Report_Objects set Config=replace(cast(Config as varchar(8000)),'VAF1 ','V_VAF_FULL ') where  datalength(Config)<8000
update Report_Objects set Config=replace(cast(Config as varchar(8000)),'VBI1 ','V_VBI_FULL ') where  datalength(Config)<8000
update Report_Objects set Config=replace(cast(Config as varchar(8000)),'VBL1 ','V_VBL_FULL ') where  datalength(Config)<8000
update Report_Objects set Config=replace(cast(Config as varchar(8000)),'DPD1 ','V_DPD1_FULL ') where  datalength(Config)<8000
update Report_Objects set Config=replace(cast(Config as varchar(8000)),'DPD2 ','V_DPD2_FULL ') where  datalength(Config)<8000
--加换行替换
update Report_Objects set Config=replace(cast(Config as varchar(8000)),'VAJ1'+char(10),'V_VAJ_FULL ') where  datalength(Config)<8000
update Report_Objects set Config=replace(cast(Config as varchar(8000)),'VAK1'+char(10),'V_VAK_FULL ') where  datalength(Config)<8000
update Report_Objects set Config=replace(cast(Config as varchar(8000)),'VAI1'+char(10),'V_VAI_FULL ') where  datalength(Config)<8000
update Report_Objects set Config=replace(cast(Config as varchar(8000)),'VBL1'+char(10),'V_VBL_FULL ') where  datalength(Config)<8000
update Report_Objects set Config=replace(cast(Config as varchar(8000)),'VAF1'+char(10),'V_VAF_FULL ') where  datalength(Config)<8000
update Report_Objects set Config=replace(cast(Config as varchar(8000)),'VBI1'+char(10),'V_VBI_FULL ') where  datalength(Config)<8000
update Report_Objects set Config=replace(cast(Config as varchar(8000)),'DPD1'+char(10),'V_DPD1_FULL ') where  datalength(Config)<8000
update Report_Objects set Config=replace(cast(Config as varchar(8000)),'DPD2'+char(10),'V_DPD2_FULL ') where  datalength(Config)<8000
--加回车替换
update Report_Objects set Config=replace(cast(Config as varchar(8000)),'VAJ1'+char(13),'V_VAJ_FULL ') where  datalength(Config)<8000
update Report_Objects set Config=replace(cast(Config as varchar(8000)),'VAK1'+char(13),'V_VAK_FULL ') where  datalength(Config)<8000
update Report_Objects set Config=replace(cast(Config as varchar(8000)),'VAI1'+char(13),'V_VAI_FULL ') where  datalength(Config)<8000
update Report_Objects set Config=replace(cast(Config as varchar(8000)),'VBL1'+char(13),'V_VBL_FULL ') where  datalength(Config)<8000
update Report_Objects set Config=replace(cast(Config as varchar(8000)),'VAF1'+char(13),'V_VAF_FULL ') where  datalength(Config)<8000
update Report_Objects set Config=replace(cast(Config as varchar(8000)),'VBI1'+char(13),'V_VBI_FULL ') where  datalength(Config)<8000
update Report_Objects set Config=replace(cast(Config as varchar(8000)),'DPD1'+char(13),'V_DPD1_FULL ') where  datalength(Config)<8000
update Report_Objects set Config=replace(cast(Config as varchar(8000)),'DPD2'+char(13),'V_DPD2_FULL ') where  datalength(Config)<8000

--针对配置脚本长度大于8000字符的手工单独处理
--select * from Report_Objects where datalength(Config)>8000

--如果出错，恢复报表
--delete Report_Objects
--insert into Report_Objects select * from Report_Objects_bak1