Stored Procedure Properties
Name | Value |
---|---|
Owner | dbo |
Created | 2004-05-31 |
Startup | False |
Encrypted | False |
Creation Options
Name | Value |
---|---|
QUOTED_IDENTIFIER | OFF |
ANSI_NULLS | OFF |
Parameters
Name | DataType | Length | Type |
---|---|---|---|
@ThreadID | int | 4 | INPUT |
@ForumID | int | 4 | INPUT |
@PrevThreadID | int | 4 | OUTPUT |
Total: 3 parameter(s)
SQL
SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO create procedure forums_GetPrevThreadID ( @ThreadID int, @ForumID int, @PrevThreadID int OUTPUT ) AS SELECT TOP 1 @PrevThreadID = ThreadID FROM Posts (nolock) WHERE ThreadID < @ThreadID AND ForumID = @ForumID AND Approved = 1 ORDER BY ThreadID DESC IF @@ROWCOUNT < 1 SELECT @PrevThreadID = 0 GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO