[dbo].[Forum_User_UpdateView]

(local) > DotNetNuke_Community > Stored Procedures > dbo.Forum_User_UpdateView

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@UserID	int	4
@PortalID	int	4
@ViewDescending	bit	1

SQL Script

CREATE PROCEDURE dbo.[Forum_User_UpdateView]
    (
      @UserID INT,
      @PortalID INT,
      @ViewDescending bit
    )
AS
    UPDATE  dbo.Forum_Users
    SET     ViewDescending = @ViewDescending
    WHERE   [UserID] = @UserID
            AND PortalID = @PortalID

GO

Uses

[dbo].[Forum_Users]
dbo