IF EXISTS (SELECT name FROM sys.objects WHERE TYPE = 'P' AND SCHEMA_NAME(schema_id) = 'dbo' AND name = 'Pr_hot_user_Update')
BEGIN
EXEC('DROP PROCEDURE [dbo].[Pr_hot_user_Update]')
END
GO
CREATE PROCEDURE [dbo].[Pr_hot_user_Update]
@userid BigInt,
@username NVarChar(100),
@registertime DateTime
AS
BEGIN
SET NOCOUNT ON
UPDATE [dbo].[hot_user] SET
[username] = @username,
[registertime] = @registertime
WHERE [userid] = @userid
IF @@ROWCOUNT = 0
BEGIN
RAISERROR('Concurrent update error. Updated aborted.', 16, 2)
END
SET NOCOUNT OFF
END
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步