CREATE PROCEDURE proc_CarUpdate
@clpzh char(20) = NULL,
@cpys varchar(4) = NULL,
AS
SET NOCOUNT ON BEGIN TRANSACTION MyTran declare @a char(20),@b varchar(4)
SELECT @a = clpzh ,@b = cpys FROM Car WHERE clpzh=?? --只有一条记录
----比较更新前和更新后的数据并写入日志
DECLARE @changeContent varchar(8000) --变更内容
IF @clpzh<>@a
set @changeContent = @clpzh 由'clpzh'改为@clpzh
INSERT CarOperateLog (
clpzh,
czrq,
sjfl)
VALUES (
@clpzh,
GetDate(),
@changeContent)
COMMIT TRANSACTION MyTran
RETURN 0
@clpzh char(20) = NULL,
@cpys varchar(4) = NULL,
AS
SET NOCOUNT ON BEGIN TRANSACTION MyTran declare @a char(20),@b varchar(4)
SELECT @a = clpzh ,@b = cpys FROM Car WHERE clpzh=?? --只有一条记录
----比较更新前和更新后的数据并写入日志
DECLARE @changeContent varchar(8000) --变更内容
IF @clpzh<>@a
set @changeContent = @clpzh 由'clpzh'改为@clpzh
INSERT CarOperateLog (
clpzh,
czrq,
sjfl)
VALUES (
@clpzh,
GetDate(),
@changeContent)
COMMIT TRANSACTION MyTran
RETURN 0
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货