62,052
社区成员
发帖
与我相关
我的任务
分享
alter proc g_modifyWealth
@userID int,
@points int
as
begin tran
update ....
if @@error<>0
goto error
insert into ...
if @@error<>0
goto error
commit tran
return 0
error:
rollback tran
return 1
go
調用:
declare @i int
exec @i=g_modifyWealth 參數1,參數2
select @i--1時失敗,0時成功
SqlConnection cn = new SqlConnection("server=.;uid=sa;pwd=;database=yourDB");
SqlCommand cmd = new SqlCommand("g_modifyWealth", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ReturnValue", SqlDbType.Int);
cmd.Parameters["@ReturnValue"].Direction = ParameterDirection.ReturnValue;
cmd.Parameters.AddWithValue("@userID ", yourUserID);
cmd.Parameters.AddWithValue("@points ", yourPoints);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
Label1.Text = cmd.Parameters["@ReturnValue"].Value.ToString();