在sql server 中找出Picklist的Value

select ent.name as entname, a2.name, a1.value, sm.value, a2.attributerequiredlevelid from ((AttributePicklistValue as a1 INNER join metadataschema.attribute as a2 on a1.attributeid = a2.attributeid) INNER JOIN metadataschema.entity as ent ON a2.entityid = ent.entityid) INNER JOIN stringmap as sm ON ent.objecttypecode = sm.objecttypecode AND a2.name = sm.attributename AND sm.attributevalue = a1.value WHERE sm.langid = '1028' ORDER BY entname, name, a1.value

转载于:https://www.cnblogs.com/janmson/archive/2009/06/29/1513288.html