22,207
社区成员
发帖
与我相关
我的任务
分享
CREATE PROCEDURE WRITE_USERBANK_LOG
@strAccount varchar(100),
@strUserID varchar(30),
@strMode varchar(1000),
@strWPName varchar(100),
@strLog varchar(1000)
AS
INSERT INTO LOG_USERBANK(str_Account,str_Name,str_LogMode,str_wpName,str_Log)
VALUES (@strAccount,@strUserID,@strMode,@strWPName,@strLog)
IF (@@ERROR <> 0)
BEGIN
ROLLBACK TRAN
RETURN 255
END
ELSE
BEGIN
COMMIT TRAN
RETURN 0
END
GO
CREATE PROCEDURE WRITE_USERBANK_LOG
@strAccount varchar(100),
@strUserID varchar(30),
@strMode varchar(1000),
@strWPName varchar(100),
@strLog varchar(1000)
AS
BEGIN TRAN
INSERT INTO LOG_USERBANK(str_Account,str_Name,str_LogMode,str_wpName,str_Log)
VALUES (@strAccount,@strUserID,@strMode,@strWPName,@strLog)
IF (@@ERROR <> 0)
BEGIN
ROLLBACK TRAN
RETURN 255
END
ELSE
BEGIN
COMMIT TRAN
RETURN 0
END
GO