ALTER PROCEDURE [dbo].[statusupdate]
(@userid INT, @status BIT)
AS
BEGIN
UPDATE Users
SET @status = IsDeleted
WHERE @userid = UserId
END
我仅根据Users
表中的userid
更新一列(IsDeleted
(。它正在执行,但不反映数据库中的更改。
你写错了代码!您需要修复以下问题。
ALTER PROCEDURE [dbo].[statusupdate]
(@userid INT, @status BIT)
AS
BEGIN
UPDATE Users
SET IsDeleted = @status
WHERE UserId = @userid
END