DECLARE @RoleID int,@UserID int,@CheckRoleID varchar(10)
Set @RoleID=12
Set @UserID=2 set @CheckRoleID=(Select RoleID From cheeda_user_role Where UserID=@UserID And RoleID=@RoleID) IF((@CheckRoleID is null) or @CheckRoleID!=@RoleID)
--如果该用户没有此权限,那们就写入权限,为什么到不了这一步?
BEGIN
PRINT '执行事务'
SAVE TRANSACTION UserRole_ADD INSERT INTO cheeda_user_role(UserID,RoleID)
VALUES(@UserID,@RoleID) IF (@@ERROR!=0 or @@ROWCOUNT=0)
BEGIN
PRINT '回滚事务'
ROLLBACK TRANSACTION UserRole_ADD
COMMIT TRAN
END
END
ELSE
PRINT '没有执行事务'
print @CheckRoleID
Set @RoleID=12
Set @UserID=2 set @CheckRoleID=(Select RoleID From cheeda_user_role Where UserID=@UserID And RoleID=@RoleID) IF((@CheckRoleID is null) or @CheckRoleID!=@RoleID)
--如果该用户没有此权限,那们就写入权限,为什么到不了这一步?
BEGIN
PRINT '执行事务'
SAVE TRANSACTION UserRole_ADD INSERT INTO cheeda_user_role(UserID,RoleID)
VALUES(@UserID,@RoleID) IF (@@ERROR!=0 or @@ROWCOUNT=0)
BEGIN
PRINT '回滚事务'
ROLLBACK TRANSACTION UserRole_ADD
COMMIT TRAN
END
END
ELSE
PRINT '没有执行事务'
print @CheckRoleID
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货