crm20011sql得到下拉框的文本

--得到下拉框的文本
go
create function GetStringMapValue
(
   @entityName varchar(100),
   @attributeName varchar(100),
   @attributeValue int
)
returns varchar(100)
as
begin
   declare @code int
   select @code = objecttypecode   from MetadataSchema.Entity where Name = @entityName
  
   declare @valueText varchar(100)
  
   select @valueText = Value
   from StringMap where AttributeName = @attributeName and AttributeValue = @attributeValue
   and ObjectTypeCode = @code
  
   return @valueText
end