CREATE PROCEDURE dbo.Forum_UserForumsAdd
    @UserID int,
    @ForumID int,
    @LastVisitDate datetime
AS
    INSERT INTO Forum_UserForums (
        UserID,
        ForumID,
        LastVisitDate
    ) VALUES (
        @UserID,
        @ForumID,
        @LastVisitDate
    )
    select SCOPE_IDENTITY()

GO