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
转载于:https://www.cnblogs.com/janmson/archive/2010/08/12/1798289.html