取到Picklist的值

DECLARE @EntityName nvarchar(100)
DECLARE @AttributeName nvarchar(100)
set @EntityName ='salesorder'
set @AttributeName='shippingmethodcode'
 SELECT a.AttributeValue , a.Value FROM
 StringMap  as a  , Entity  b
 where   
        a.ObjectTypeCode=b.ObjectTypeCode
        AND b.Name=@EntityName
        and a.LangId =2052
        and a.AttributeName = @AttributeName