导航

CRM stringmap

Posted on 2018-08-30 11:18  yiyishuitian  阅读(280)  评论(0)    收藏  举报 
        CREATE view [dbo].[V_stringmap] as 



SELECT DISTINCT   Entity.Name as tablename,StringMap.AttributeName as columnname,StringMap.AttributeValue,StringMap.Value

from Entity join StringMap on StringMap.ObjectTypeCode = Entity.ObjectTypeCode