/* 币别.名称 */
UPDATE t_bd_currency set FNAME = ISNULL((select max(tl.FNAME) from t_bd_currency_l tl where t_bd_currency.FId = tl.FId AND flocaleid = 'zh_CN'), ' ') where FNAME is null or FNAME = ' ';
/* 币别.描述 */
UPDATE t_bd_currency set FDESCRIPTION = ISNULL((select max(tl.FDESCRIPTION) from t_bd_currency_l tl where t_bd_currency.FId = tl.FId AND flocaleid = 'zh_CN'), ' ') where FDESCRIPTION is null or FDESCRIPTION = ' ';


/* 国家地区.名称 */
UPDATE t_bd_country set FNAME = ISNULL((select max(tl.FNAME) from t_bd_country_l tl where t_bd_country.FId = tl.FId AND flocaleid = 'zh_CN'), ' ') where FNAME is null or FNAME = ' ';
/* 国家地区.全称 */
UPDATE t_bd_country set FFULLNAME = ISNULL((select max(tl.FFULLNAME) from t_bd_country_l tl where t_bd_country.FId = tl.FId AND flocaleid = 'zh_CN'), ' ') where FFULLNAME is null or FFULLNAME = ' ';
/* 国家地区.英文全称 */
UPDATE t_bd_country set FDESCRIPTION = ISNULL((select max(tl.FDESCRIPTION) from t_bd_country_l tl where t_bd_country.FId = tl.FId AND flocaleid = 'en_US'), ' ') where FDESCRIPTION is null or FDESCRIPTION = ' ';

/* 行政区划.名称 */
UPDATE t_bd_admindivision set FNAME = ISNULL((select max(tl.FNAME) from t_bd_admindivision_l tl where t_bd_admindivision.FId = tl.FId AND flocaleid = 'zh_CN'), ' ') where FNAME is null or FNAME = ' ';
/* 行政区划.长名称 */
UPDATE t_bd_admindivision set FFULLNAME = ISNULL((select max(tl.FFULLNAME) from t_bd_admindivision_l tl where t_bd_admindivision.FId = tl.FId AND flocaleid = 'zh_CN'), ' ') where FFULLNAME is null or FFULLNAME = ' ';
/* 行政区划.描述 */
UPDATE t_bd_admindivision set FDESCRIPTION = ISNULL((select max(tl.FDESCRIPTION) from t_bd_admindivision_l tl where t_bd_admindivision.FId = tl.FId AND flocaleid = 'zh_CN'), ' ') where FDESCRIPTION is null or FDESCRIPTION = ' ';

/* 计量单位.名称 */
UPDATE t_bd_measureunit set FNAME = ISNULL((select max(tl.FNAME) from t_bd_measureunit_l tl where t_bd_measureunit.FId = tl.FId AND flocaleid = 'zh_CN'), ' ') where FNAME is null or FNAME = ' ';

/* 语言种类.名称 */
UPDATE t_int_language set FNAME = ISNULL((select max(tl.FNAME) from t_int_language_l tl where t_int_language.FId = tl.FId AND flocaleid = 'zh_CN'), ' ') where FNAME is null or FNAME = ' ';
/* 语言种类.描述 */
UPDATE t_int_language set FDESCRIPTION = ISNULL((select max(tl.FDESCRIPTION) from t_int_language_l tl where t_int_language.FId = tl.FId AND flocaleid = 'zh_CN'), ' ') where FDESCRIPTION is null or FDESCRIPTION = ' ';

/* 时区.名称 */
UPDATE t_int_timezone set FNAME = ISNULL((select max(tl.FNAME) from t_int_timezone_l tl where t_int_timezone.FId = tl.FId AND flocaleid = 'zh_CN'), ' ') where FNAME is null or FNAME = ' ';
/* 时区.描述 */
UPDATE t_int_timezone set FDESCRIPTION = ISNULL((select max(tl.FDESCRIPTION) from t_int_timezone_l tl where t_int_timezone.FId = tl.FId AND flocaleid = 'zh_CN'), ' ') where FDESCRIPTION is null or FDESCRIPTION = ' ';
/* 时区.简码 */
UPDATE t_int_timezone set FSIMPLECODE = ISNULL((select max(tl.FSIMPLECODE) from t_int_timezone_l tl where t_int_timezone.FId = tl.FId AND flocaleid = 'zh_CN'), ' ') where FSIMPLECODE is null or FSIMPLECODE = ' ';

/* 区域格式.名称 */
UPDATE t_int_formatplan set FNAME = ISNULL((select max(tl.FNAME) from t_int_formatplan_l tl where t_int_formatplan.FId = tl.FId AND flocaleid = 'zh_CN'), ' ') where FNAME is null or FNAME = ' ';
/* 区域格式.描述 */
UPDATE t_int_formatplan set FDESCRIPTION = ISNULL((select max(tl.FDESCRIPTION) from t_int_formatplan_l tl where t_int_formatplan.FId = tl.FId AND flocaleid = 'zh_CN'), ' ') where FDESCRIPTION is null or FDESCRIPTION = ' ';

/* 行政级次.名称 */
UPDATE t_bd_admindivisionlevel set FNAME = ISNULL((select max(tl.FNAME) from t_bd_admindivisionlevel_l tl where t_bd_admindivisionlevel.FId = tl.FId AND flocaleid = 'zh_CN'), ' ') where FNAME is null or FNAME = ' ';




