USP_DATALIST_LANGUAGERESOURCESFORCONTENT

Returns all localized language strings for a piece of content.

Parameters

Parameter	Parameter Type	Mode	Description
@CONTENTID	int	IN	Content ID
@CULTURECODE	nvarchar(10)	IN	Culture code
@RESOURCETYPE	nvarchar(255)	IN	Resource type

Definition

Copy



CREATE procedure dbo.USP_DATALIST_LANGUAGERESOURCESFORCONTENT
(
                @CONTENTID int,
                @CULTURECODE nvarchar(10),
                @RESOURCETYPE nvarchar(255)
)
as
                select r.RESOURCEKEY as ResourceKey, 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;