asp.net C# ÏòSQL¶à±í²åÈëÊý¾ÝÎÊÌâ

      SQLÓжà¸ö¹ØÁªµÄ±í£¬Ò»´ÎÏòÕ⼸¸ö±íÖÐͬʱ²åÈë
     
      ±ÈÈ磬ÎÒÔÚÒ»¸ö°´Å¥Ê¼þÖУ¬»ñȡǰ̨ҳÃæÖеÄÖµ£¬È»ºó²åÈëÊý¾Ý£¬ÕâЩÊý¾Ý¹ØÁªÁËÈý¸ö±í£¬²¢ÇÒÕâЩ±íÓÐÖ÷¼ü£¬Íâ¼ü

¹ØÁª£¬£¬¸ÃÔõôŪ°¡£¿£¿£¿


      ×îºÃÀý×Ó˵¹þa

---

ʹÓô洢¹ý³Ì
create procedure Add
@A varchar(200)
as
insert into Tb1(A) values(@A)
select @id=max(id) from Tb1
»ò@@identity

---

²»¾ÍÊÇͬʱִÐÐ3Ìõsql£¬ÊµÏÖÊÂÎï

---

Ò²¿ÉÒ»¿¼ÂÇÓô¥·¢Æ÷~

---

ÒýÓÃ

²»¾ÍÊÇͬʱִÐÐ3Ìõsql£¬ÊµÏÖÊÂÎï

Ôõô¸öʵÏÖ·¨£¿ÁíÍâÓô洢¹ý³ÌÔõô×öÄØ£¿¾ßÌåµã°¡

---

ÈçºÎд´æ´¢¹ý³Ì£¿¶à±í¹ØÁª ²åÈëÊý¾Ý£¿£¿£¿

---

ÊÂÎñ
C# code:

SqlConnection conn = Database.ReturnConn();
SqlTransaction trans = conn.BeginTransaction();
try
{
//²åÈë1Ìõ¼Ç¼
//²åÈë1Ìõ¼Ç¼

//²åÈë1Ìõ¼Ç¼


trans.Commit();
}
catch ()
{
trans.Rollback();
}
finally
{
conn.Close();
}

---

ÄãÓ¦¸Ã»áÓóÌÐòµ÷Óô洢¹ý³Ì°É
SQL code

---

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHi