if exists(SELECT ID FROM ReplyLeaveWord WHERE MessageID =@MessageID) update ReplyLeaveWord set ReplyContent = @ReplyContent where MessageID = @MessageID else insert into ReplyLeaveWord ( ReplyContent, LeaveTime, MessageID ) values ( @ReplyContent, getdate(), @MessageID ) if @@error = 0 and @@rowcount > 0 set @returnVal = 1; else set @returnVal = -1;这个存储过程,添加就能用,可更新就不成功。
exists(SELECT ID FROM ReplyLeaveWord WHERE MessageID =@MessageID) 已经存在了,表中有的。网页中也能显示。
这个存储过程,添加就能用,可更新就不成功。MessageID 条件列不可更新
你在查询分析器中看看是否有输出'进入Update了' if exists(SELECT ID FROM ReplyLeaveWord WHERE MessageID =@MessageID) Begin Print '进入Update了' -- update ReplyLeaveWord set ReplyContent = @ReplyContent where MessageID = @MessageID End else insert into ReplyLeaveWord ( ReplyContent, LeaveTime, MessageID ) values ( @ReplyContent, getdate(), @MessageID ) if @@error = 0 and @@rowcount > 0 set @returnVal = 1; else set @returnVal = -1;
update ReplyLeaveWord
set
ReplyContent = @ReplyContent
where
MessageID = @MessageID
else
insert into ReplyLeaveWord
(
ReplyContent,
LeaveTime,
MessageID
)
values
(
@ReplyContent,
getdate(),
@MessageID
)
if @@error = 0 and @@rowcount > 0
set @returnVal = 1;
else
set @returnVal = -1;这个存储过程,添加就能用,可更新就不成功。
已经存在了,表中有的。网页中也能显示。
if exists(SELECT ID FROM ReplyLeaveWord WHERE MessageID =@MessageID)
Begin
Print '进入Update了' --
update ReplyLeaveWord
set
ReplyContent = @ReplyContent
where
MessageID = @MessageID
End
else
insert into ReplyLeaveWord
(
ReplyContent,
LeaveTime,
MessageID
)
values
(
@ReplyContent,
getdate(),
@MessageID
)
if @@error = 0 and @@rowcount > 0
set @returnVal = 1;
else
set @returnVal = -1;
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
}
}