cs_thread_prevnext.prc

解压即可使用

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[cs_Thread_PrevNext]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[cs_Thread_PrevNext]
GO



CREATE procedure [dbo].cs_Thread_PrevNext
(
	@ThreadID int,
	@SectionID int,
	@SettingsID int,
	@NextThreadID int OUTPUT,
	@PrevThreadID int OUTPUT
)
AS
DECLARE @ThreadDate datetime

/*
SELECT 
	@ThreadDate = StickyDate 
FROM 
	cs_Threads
WHERE
	ThreadID = @ThreadID and SettingsID = @SettingsID


SELECT TOP 1 
	@PrevThreadID = T.MostRecentPostID
FROM 
	cs_Threads T 
WHERE 
	T.SectionID = @SectionID AND 
	T.IsApproved = 1 AND
	StickyDate < @ThreadDate AND	
	T.SettingsID = @SettingsID
ORDER BY 
	IsSticky DESC, 
	StickyDate DESC

IF @@ROWCOUNT < 1
	SELECT @PrevThreadID = 0


SELECT TOP 1 
	@NextThreadID = T.MostRecentPostID 
FROM 
	cs_Threads T 
WHERE 
	T.SectionID = @SectionID AND 
	T.IsApproved = 1 AND
	StickyDate > @ThreadDate AND
	T.SettingsID = @SettingsID
ORDER BY 
	IsSticky ASC, 
	StickyDate ASC

IF @@ROWCOUNT < 1
	SELECT @NextThreadID = 0
*/

	SELECT @PrevThreadID = 0
	SELECT @NextThreadID = 0
GO


GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

grant execute on [dbo].[cs_Thread_PrevNext] to public
go