cs_forums_GetForumModerators
ALTER PROCEDURE [dbo].cs_forums_GetForumModerators
(
@SectionID int,
@SettingsID int
)
AS
SET Transaction Isolation Level Read UNCOMMITTED
/**//*设置事务隔离级别,Read UNCOMMITTED 执行脏读或 0 级隔离锁定,这表示不发出共享锁,
也不接受排它锁。当设置该选项时,可以对数据执行未提交读或脏读;在事务结束前可以更
改数据内的数值,行也可以出现在数据集中或从数据集消失。该选项的作用与在事务内所有
语句中的所有表上设置 NOLOCK 相同。这是四个隔离级别中限制最小的级别。*/
-- get a list of forum moderators
-- 获取版主的列表?
SELECT
UserName, EmailNotification, DateCreated
FROM
Moderators (nolock)
WHERE
(SectionID = @SectionID OR SectionID = 0) and SettingsID = @SettingsID
ALTER PROCEDURE [dbo].cs_forums_GetForumModerators
(
@SectionID int,
@SettingsID int
)
AS
SET Transaction Isolation Level Read UNCOMMITTED
/**//*设置事务隔离级别,Read UNCOMMITTED 执行脏读或 0 级隔离锁定,这表示不发出共享锁,
也不接受排它锁。当设置该选项时,可以对数据执行未提交读或脏读;在事务结束前可以更
改数据内的数值,行也可以出现在数据集中或从数据集消失。该选项的作用与在事务内所有
语句中的所有表上设置 NOLOCK 相同。这是四个隔离级别中限制最小的级别。*/
-- get a list of forum moderators
-- 获取版主的列表?
SELECT
UserName, EmailNotification, DateCreated
FROM
Moderators (nolock)
WHERE
(SectionID = @SectionID OR SectionID = 0) and SettingsID = @SettingsID
cs_forums_GetForumMessages
ALTER procedure [dbo].cs_forums_GetForumMessages
(
@MessageID int = 0,
@SettingsID int
)
AS
SET Transaction Isolation Level Read UNCOMMITTED
/**//*设置事务隔离级别,Read UNCOMMITTED 执行脏读或 0 级隔离锁定,这表示不发出共享锁,
也不接受排它锁。当设置该选项时,可以对数据执行未提交读或脏读;在事务结束前可以更
改数据内的数值,行也可以出现在数据集中或从数据集消失。该选项的作用与在事务内所有
语句中的所有表上设置 NOLOCK 相同。这是四个隔离级别中限制最小的级别。*/
-----------------------------------------------------------------------------
/**//*如果输入为0,查找全部消息,如果不为0,查询此条消息*/
IF @MessageID = 0
SELECT
*
FROM
cs_Messages where SettingsID = @SettingsID
ELSE
SELECT
*
FROM
cs_Messages
WHERE
MessageID = @MessageID and SettingsID = @SettingsID
ALTER procedure [dbo].cs_forums_GetForumMessages
(
@MessageID int = 0,
@SettingsID int
)
AS
SET Transaction Isolation Level Read UNCOMMITTED
/**//*设置事务隔离级别,Read UNCOMMITTED 执行脏读或 0 级隔离锁定,这表示不发出共享锁,
也不接受排它锁。当设置该选项时,可以对数据执行未提交读或脏读;在事务结束前可以更
改数据内的数值,行也可以出现在数据集中或从数据集消失。该选项的作用与在事务内所有
语句中的所有表上设置 NOLOCK 相同。这是四个隔离级别中限制最小的级别。*/
-----------------------------------------------------------------------------
/**//*如果输入为0,查找全部消息,如果不为0,查询此条消息*/
IF @MessageID = 0
SELECT
*
FROM
cs_Messages where SettingsID = @SettingsID
ELSE
SELECT
*
FROM
cs_Messages
WHERE
MessageID = @MessageID and SettingsID = @SettingsID
cs_Folder_RenameFolder
ALTER PROC [dbo].cs_Folder_RenameFolder
@FolderId INT,
@FolderName NVARCHAR(50)
AS
/**//*重命名FolderName*/
UPDATE cs_Folder
SET FolderName = @FolderName
WHERE FolderId = @FolderId
ALTER PROC [dbo].cs_Folder_RenameFolder
@FolderId INT,
@FolderName NVARCHAR(50)
AS
/**//*重命名FolderName*/
UPDATE cs_Folder
SET FolderName = @FolderName
WHERE FolderId = @FolderId