[dbo].[Forum_ThreadViewsIncrement]

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

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@ThreadID	int	4

SQL Script

CREATE PROCEDURE dbo.Forum_ThreadViewsIncrement
(
@ThreadID int
)
AS
UPDATE
    Forum_Threads
SET
    [Views] = ((SELECT [Views] FROM Forum_Threads (nolock) WHERE [ThreadID] = @ThreadID) + 1)
WHERE
    [ThreadID] = @ThreadID

GO

Uses

[dbo].[Forum_Threads]
dbo