--升级辅助属性历史数据
IF EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_MFTORDERENTRY_S' AND KSQL_COL_NAME ='FAUXPROPERTYNEW') 
		UPDATE T_POM_MFTORDERENTRY_S s  set FAUXPROPERTYNEW=(select FAUXPROPERTY from T_POM_MFTORDERENTRY t where s.forderentryid=t.fENTRYID)   where s.FAUXPROPERTYNEW=0 and s.FAUXPROPERTY<>' ';
		
		
		
		
		
		
