古怪的问题。调试存储过程没有反应。比如我删除一条记录。但是使用EXEC 确可以执行成功
CREATE proc forums_Friend_CreateUpdateDelete
(
@FriendID int out,
@DeleteFriend bit = 0,
@remark nvarchar(500),
@FriendUserID int,
@UserID int
)
AS
--we are delete
if (@DeleteFriend=1)
begin
delete from forums_friend where FriendID=@FriendID
return
end
---- are we updating the rank
if (@FriendID>0)
begin
update forums_friend set remark=@remark where friendid=@friendid
end
else
begin
insert into forums_friend
(userid,frienduserid,remark)
values
(@userid,@friendUserID,@remark)
set @FriendID = @@identity
end
GO
郁闷死了。
提供几个参数给大家
@FriendID=0
@DeleteFriend=0
@remark=afsljfosfkw
@FriendUserID=2
@UserID=3
通过程序调用存储过程,失败@!
通过调试存储过程,失败。
但通过EXEC forums_Friend_CreateUpdateDelete 确成功。郁闷