thread.sql

来自「This is not a very mean things」· SQL 代码 · 共 69 行

CREATE PROCEDURE GetSingleThread
(
    @ThreadID int
)
AS
SELECT
	 
	ThreadID,
	Author,
	Subject,
	Content,
	PostTime,
	TotalView,
	Reply
FROM
    Threads
WHERE
    ThreadID = @ThreadID
GO

CREATE PROCEDURE ClickThread
(
    @ThreadID int
)
AS
Update 
    Threads
Set TotalView =TotalView +1
WHERE
    ThreadID = @ThreadID
GO


CREATE PROCEDURE [AddMessage]
	( 
	@ThreadID int,
	@Author nvarchar(50),
	@Subject nvarchar(50),
	@Content ntext)

AS INSERT INTO [Messages] 
	 ( 
	ThreadID,
	Author,
	Subject,
	Content ) 
 
VALUES 
	( 
	@ThreadID,
	@Author,
	@Subject,
	@Content )
GO

CREATE PROCEDURE ReplyThread
(
    @ThreadID int
)
AS
Update 
    Threads
Set Reply =Reply +1
WHERE
    ThreadID = @ThreadID
GO