一、U9私有扩展字段的多语言表的SQL更新说明
1.代码如下:
Select SMSL.ID as ID,
ISNULL(UBF_Sys_E1.Code, '') as Code,
ISNULL(UBF_Sys_ET1.name, '') as Name,
'zh-CN' as SysMLFlag
Into #TempDataID
from SM_Shipline as SMSL
join UBF_Sys_ExtEnumValue as UBF_Sys_E1 on SMSL.DescFlexField_PrivateDescSeg2=UBF_Sys_E1.Code
left join [UBF_Sys_ExtEnumValue_Trl] as UBF_Sys_ET1 on (UBF_Sys_ET1.SysMlFlag='zh-CN') and (UBF_Sys_E1.[ID]=UBF_Sys_ET1.[ID])
where SMSL.ID='1001605211160465'
and UBF_Sys_E1.[ExtEnumType]=1001510090000043
--select * from #TempDataID
exec P_Samuel_CombineNameUpdate 'SM_Shipline','#TempDataID',52
DropTable #TempDataID
其中:UBF_Sys_E1.Code是枚举编码,UBF_Sys_ET1.name是枚举名称,SMSL.ID是更新的表记录ID,TempDataID 是存储更新表记录的ID,枚举编码,枚举名称和语言的临时表,P_Samuel_CombineNameUpdate是更新多语言表的存储过程,SM_Shipline是要更新的表的名称,52,是扩展第二个字段。扩展第一个字段是51,第三是53,依次类推。
评论区