Stored Procedures [dbo].[Forum_UserUpdateTrackingDuration]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@TrackingDurationint4
@UserIDint4
@PortalIDint4
SQL Script


CREATE PROCEDURE dbo.[Forum_UserUpdateTrackingDuration]
    @TrackingDuration INT,
    @UserID INT,
    @PortalID INT
AS
    BEGIN

        UPDATE  dbo.Forum_Users
        SET     TrackingDuration = @TrackingDuration
        WHERE   UserID = @UserID
                AND PortalID = @PortalID
    END

GO
Uses