fnPartNameInUse

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode
@Title	nvarchar(256)	IN
@ContentTypesID	int	IN
@ClientSitesID	int	IN
@ContentID	int	IN

Definition

Copy



        CREATE FUNCTION [dbo].[fnPartNameInUse] 
    (
    @Title NVARCHAR(256),
    @ContentTypesID INT,
    @ClientSitesID  INT,
    @ContentID INT
    )
    RETURNS INTEGER AS

    BEGIN
        RETURN
        (
        SELECT 
            TOP 1 ID 
        FROM 
            dbo.SiteContent 
        WHERE 
            [Title]=@Title 
            AND ContentTypesID=@ContentTypesID
            AND ClientSitesID=@ClientSitesID
            AND ID <> @ContentID
        )
    END