creat PROCEDURE Finance--存储过程
@Balance int--传进来的参数
AS
begin
if(@Balance == 2)--如果传进来的参数是2
begin
update tablename
set lie=lie+@Balance , llee=llee-@Balance
where idid = 1--更新两列数据
end
if(@Balance == 4)
begin
update tablename
set lie=lie+@Balance , llee=llee-@Balance
where idid = 1
end目前的错误:1、if(@Balance==2) 2、set lie=lie+@Balance , llee=llee-@Balance
set llee=llee-@Balance
create PROCEDURE Finance--存储过程
@Balance int--传进来的参数
AS
begin
if(@Balance = 2)--如果传进来的参数是2
begin
update tablename set lie=lie+@Balance,llee=llee-@Balance
where idid = 1--更新两列数据
end
if(@Balance = 4)
begin
update tablename set lie=lie+@Balance , llee=llee-@Balance where idid = 1
end