spGetSiteContentSearchText

            CREATE PROCEDURE spGetSiteContentSearchText 
                @SiteContentID int = 0
            AS
            BEGIN
                -- SET NOCOUNT ON added to prevent extra result sets from
                -- interfering with SELECT statements.
                SET NOCOUNT ON;

                SELECT s.SearchText
                FROM [dbo].[Search] s
                WHERE s.[SiteContentID] = @SiteContentID
                AND s.[ExtendedKey] = ''

            END