帖子回复表(使用分表技术)

TopicDB_x_RevertDB (X为自动增量)

ID  OleDbType.Integer 
TopicID  OleDbType.Integer 帖子ID
RevertContent OleDbType.VarWChar 回复内容
UserID  OleDbType.Integer 用户ID
RevertTime OleDbType.Date  回复时间
UpdateTime OleDbType.Date  更新时间
UpdateMan OleDbType.VarWChar(20) 更新作者

说明:14为自动增量
//根据ID更新回复数据
名称:
UpdateOnID_TopicDB_14_RevertDB
SQL:
UPDATE TopicDB_14_RevertDB
SET TopicDB_14_RevertDB.RevertContent = @RevertContent,
TopicDB_14_RevertDB.UpdateTime = Now(),
TopicDB_14_RevertDB.UpdateMan = @UpdateMan
WHERE TopicDB_14_RevertDB.ID = [@ID];

//根据ID获取数据
名称:
GetDataOnID_TopicDB_14_RevertDB
SQL:
SELECT TopicDB_14_RevertDB.RevertContent
FROM TopicDB_14_RevertDB
WHERE TopicDB_14_RevertDB.ID=[@ID];

//根据帖子ID删除回复数据
名称:
DelOnTopicID_TopicDB_9_RevertDB
SQL:
DELETE TopicDB_9_RevertDB.TopicID, *
FROM TopicDB_9_RevertDB
WHERE TopicDB_9_RevertDB.TopicID=[@TopicID];

删除回复数据:
DelOnID_TopicDB_4_RevertDB
SQL:
DELETE TopicDB_4_RevertDB.ID, *
FROM TopicDB_4_RevertDB
WHERE TopicDB_4_RevertDB.ID = @ID;

添加回复数据
AddData_TopicDB_22_RevertDB
SQL:
INSERT INTO TopicDB_22_RevertDB
( TopicID, RevertContent, UserID, UpdateMan )
SELECT @TopicID AS 表达式1, @RevertContent AS 表达式2, @UserID AS 表达式3, @UpdateMan AS 表达式4;

获取回复数据表统计数据:
GetCountID_TopicDB_6_RevertDB
SQL:
SELECT Count(ID)
FROM TopicDB_6_RevertDB;