fnNetAccountRelationship_BlockedID

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@NetAccountID	int	IN
@FriendNetAccountID	int	IN

Definition

Copy




CREATE FUNCTION dbo.fnNetAccountRelationship_BlockedID
    (
    @NetAccountID int,
    @FriendNetAccountID int
    )
    RETURNS int
    AS
    BEGIN
    RETURN (

    SELECT TOP 1 BlockedID
    FROM [NetAccountRelation] 
    WHERE
    (NetAccountID = @NetAccountID AND RelationAccountID = @FriendNetAccountID)
    OR
    (NetAccountID = @FriendNetAccountID AND RelationAccountID = @NetAccountID)
    )

    END