[dbo].[Forum_UserUpdateTrackingDuration]
(local)
>
DotNetNuke_Community
>
Stored Procedures
> dbo.Forum_UserUpdateTrackingDuration
Properties
Parameters
SQL Script
Uses
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
Parameters
Name
Data Type
Max Length (Bytes)
@TrackingDuration
int
4
@UserID
int
4
@PortalID
int
4
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
[dbo].[Forum_Users]
dbo