USP_DATALIST_LANGUAGE_RESOURCES_BY_KEY

Returns a single localized string based on a key

Parameters

Parameter	Parameter Type	Mode
@ContentID	int	IN
@CultureCode	nvarchar(5)	IN
@ResourceType	nvarchar(50)	IN
@ResourceKey	nvarchar(50)	IN

Definition

Copy



CREATE procedure dbo.USP_DATALIST_LANGUAGE_RESOURCES_BY_KEY
(
                @ContentID int,
                @CultureCode nvarchar(5),
                @ResourceType nvarchar(50),
                @ResourceKey nvarchar(50)
)
as
                select r.ResourceValue as DefaultValue, o.Text as PartValue
                from dbo.LANGUAGE_RESOURCES r left outer join dbo.LANGUAGE_RESOURCES_OVERRIDES o
                on r.ID = o.LANGUAGERESOURCEGUID and o.CONTENTID = @ContentID
                where CultureCode = @CultureCode and ResourceType = @ResourceType and ResourceKey = @ResourceKey;