insertÓï¾äÖ§³Ö»Ø¹öÂð

ÄãÕâÀïÓÐ2¸öinsertÓï¾ä
Ò»¸ö³É¹¦Ò»¸öʧ°Ü
SQLĬÈÏÖ»»Ø¹ö(rollback)³ö´íµÄÓï¾äÒâ˼Êdzɹ¦µÄÓï¾ä²»Äܻعö

µ«ÊǺÜÆæ¹ÖÕâ¸öÓï¾äûÓÐÎÊÌâ°¡
ÔÚÎÒÎÊ´ðµÄ»úÆ÷ÉÏÕý³£ÔËÐÐ
½á¹û»á´òÓ¡bad

½á¹ûµ±È»Ã»ÓÐÁË
ÊÂÎñÊÇ´ÓÍ·¿ªÊ¼µÄµÚ2²½´íÁ˻عöÊÂÎñ·þÏ൱ÓÚÊÂÎñÖ´ÐÐ֮ǰµÄ

--²¹³ä
ÔÚÒ»¸öÊÂÎñÀïÃæÒ»¶¨ÃºÊÇÈ«»Ø¹ö
ÏëÒªÖ»»Ø¹ö³ö´íµÄ¾ÍÒª°Ñ²Ù×÷·Ö¿ªÒ»¸öinsertÒ»¸öÊÂÎñ


¾Û¾ÉÌâ²ÉÉܸúתÀëbegintran
declare@oneint,@twoint,@cchar(10),@dchar(10)
select@c='good'
select@d='bad'
insertintostu_unionvalues('3','¼¸',14)
select@one¹©Äê»áÍõÖسÉ˹Ê**Ù¾§Ö´=@@error
ifÏÞ¸ÖµçËãºâµÄÏ@one=0
begiÈ»Ëð°Ñ²¨±øÇ°±£Æ¤¶În
print@c
committran
end
el¿ó½çÇìÕþse
begin
print@d
rollbacktÂý·ÖôÊõran
end

begintran
insertintostu_unionvalues(**LL,'Àîij'·¹,18)
select@two=@@error
if@two=0
begin
print@c
committran
end
else
be·´»÷À­·þÊ÷×ÚÒ׵͹ٲìgin
print@¿àÔøºâËüÌú´òd
rollbacktra·Ön
end