fnGetNetAccountRelationID

Return

Return Type
int

Parameters

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

Definition

Copy




        CREATE FUNCTION [dbo].[fnGetNetAccountRelationID]
        (
            @NetAccountID int,
            @FriendNetAccountID int
        )
            RETURNS int
            AS

            BEGIN
            RETURN(

            SELECT ID
            FROM [NetAccountRelation] 
            WHERE
            (NetAccountID = @NetAccountID AND RelationAccountID = @FriendNetAccountID)
            OR
            (NetAccountID = @FriendNetAccountID AND RelationAccountID = @NetAccountID)
            )
            END