begin tran tran_AddUserInfo --開始事務(wù)
declare @tran_error int;
set @tran_error=0;
begin try
 insert into dbo.UserInfo values(2016009,'aaa','2016-08-19 09:13:41.227','男')
 insert into dbo.UserInfo values(2016009,'bbb','2016-08-19 09:13:41.227','哼哼哼')
 insert into dbo.UserInfo values(2016009,'ccc','2016-08-19 09:13:41.227','哈哈哈')
end try
begin catch
 set @tran_error=@tran_error+1; --加分號(hào)或不加都能正常執(zhí)行
end catch
if(@tran_error>0)
begin
 rollback tran tran_AddUserInfo; --執(zhí)行出錯(cuò)，回滾事務(wù)(指定事務(wù)名稱)
 print @tran_error;
end
else
begin
 commit tran tran_AddUserInfo; --沒有異常，提交事務(wù)(指定事務(wù)名稱)
 print @tran_error;
end

begin tran tran_AddUserInfo --開始事務(wù)
declare @tran_error int;
set @tran_error=0;
begin try
 insert into dbo.UserInfo values(2016009,'aaa','2016-08-19 09:13:41.227','男')
 insert into dbo.UserInfo values(2016009,'bbb','2016-08-19 09:13:41.227','哈哈')
 insert into dbo.UserInfo values(2016009,'ccc','2016-08-19 09:13:41.227','哈哈')
end try
begin catch
 set @tran_error=@tran_error+1; --加分號(hào)或不加都能正常執(zhí)行
end catch
if(@tran_error>0)
begin
 rollback tran; --執(zhí)行出錯(cuò)，回滾事務(wù)(不指定事務(wù)名稱)
 print @tran_error;
end
else
begin
 commit tran; --沒有異常，提交事務(wù)(不指定事務(wù)名稱)
 print @tran_error;
end

public partial class TestSqlTran : System.Web.UI.Page
{
  protected void Page_Load(object sender, EventArgs e)
  {
    if(!IsPostBack)
    {
      Execute();
    }
  }
  private void Execute()
  {
    string connString = ConfigurationManager.ConnectionStrings["connString"].ToString();
    SqlConnection connection = new SqlConnection(connString);
    StringBuilder sqlSB=new StringBuilder();
    /*sqlSB.AppendLine("begin tran tran_handle")與SqlServer中的換行不是一回事,
     C#后臺(tái)每行Sql語句后邊必須加空格分隔,
     不能用sqlSB.AppendLine("begin tran tran_handle")來替代sqlSB.Append("begin tran tran_handle ")
    */
    sqlSB.Append("begin tran tran_handle ");
    sqlSB.AppendFormat("declare {0} int;set {0}=0;", "@tran_error");
    sqlSB.Append("begin try ");
    sqlSB.AppendFormat("delete from Descriptions where Id='{0}' ", "1");
    sqlSB.Append("end try ");
    sqlSB.Append("begin catch ");
    //set @tran_error=@tran_error+1;以分號(hào)結(jié)尾可以不用空格
    sqlSB.Append("set @tran_error=@tran_error+1;");
    sqlSB.Append("end catch ");
    sqlSB.Append("if(@tran_error>0) begin rollback tran; end ");
    sqlSB.Append("else begin commit tran; end ");
    SqlCommand cmd=new SqlCommand(sqlSB.ToString(),connection);
    connection.Open();
    int count = cmd.ExecuteNonQuery();
    connection.Close();
  }
}