列前缀与查询中所用的表名或列名不匹配
CREATE PROC Pr_UpdateBoardInfo
(
@BoardID INT,
@board VARCHAR(100),
@newModeratorID VARCHAR(20)
)
AS
BEGIN TRAN
--修改版块名称
IF Boards.Board <> @board //此处出错
BEGIN
UPDATE Boards
SET Boards.Board = @board
WHERE BoardID = @BoardID
END
IF @@ERROR <> 0
ROLLBACK TRAN
--修改版主,调用Pr_AppointModerator存储过程,他内部自定义了事务
IF @newModeratorID <> Boards.ModeratorID //此处出错
EXECUTE [Pr_AppointModerator]
@boardID = @BoardID, -- int
@newModID = @newModeratorID -- varchar(20)
总出错 列前缀 'Boards' 与查询中所用的表名或别名不匹配。出错的地方用注释表出来了
Boards表结构
BoardsID int not null
Board varchar 100 not null
ModeratorID varchar 20