delphiÈçºÎ»ñÈ¡mssql´æ´¢¹ý³ÌµÄ·µ»ØÖµ
´æ´¢¹ý³ÌÊÇÕâôдµÄ£¬
Declare @id int
BEGIN TRANSACTION
Insert into xxxxxTable(f1,f2)values(@a,@b)
Select @id=@@identity
Insert into abcTable(ff1,ff2,ff3)values(@c,@id,@dd)
IF @@error <> 0 --·¢Éú´íÎó
BEGIN
ROLLBACK TRANSACTION
RETURN 0
END
ELSE
BEGIN
COMMIT TRANSACTION
RETURN 1 --Ö´Ðгɹ¦
END
ÎÒÏëÖªµÀ£¬Ó¦ÓóÌÐòÈçºÎÖªµÀ´æ´¢¹ý³Ì·µ»ØÁË1»¹ÊÇ0ÄØ£¿
²âÊÔ"´æ´¢¹ý³Ì"ÃûÊÇ·ñ´æÔÚ
if not ´æ´¢¹ý³ÌÃû then
begin
Ö´Ðд洢¹ý³Ì;
±äÁ¿=1; //Õæ
end
else
±äÁ¿=0;
Â¥Ö÷¿ÉÒÔ½¨Ò»¸ö´øÊä³ö²ÎÊýµÄ´æ´¢¹ý³Ì ¼´²ÎÊýÓÃoutput¡¡±êʶ
ÏêϸÇë²ÎÔÄSQLSERVER°ïÖú£¬¿Ï¶¨»áÓиü¶àµÄÊÕ»ñ¡£
´æ´¢¹ý³ÌÖ»·µ»ØÒ»¸öÕûÊý¿ÉÒÔÓÃoutput²ÎÊý¡£
ÔÚdelphiÖÐÒÔ²ÎÊýÐÎʽ¾ÍÄÜ»ñȡֵ¡£
ADOSto
Ïà¹ØÎÊ´ð£º
¾ÍÊÇÒ»¸ö·þÎñ¶ËºÍÒ»¸ö¿Í»§¶Ë£¬Àï±ßÓÐһЩ¹²Óõ¥Ôª £¬ÎÒÔÚ ¹¤³ÌµÄSEARCH PATHÀïÉèÖõÄ·¾¶£¬
Àï±ßÓиö½á¹¹Ì壬ÎÒÔÚ·þÎñ¶Ë´ò¿ª£¬¼ÓÁ˳ÉÔ±£¬µ«ÊÇÎÒÔÚ¿Í»§¶ËÆäËûµ¥Ôª·ÃÎʲ»µ½ÎÒмӵģ¬ÎÒÔÚ¿Í»§¶Ë´ò¿ªÄǸöµ¥Ôª£¬È·Êµ¼ÓÁ ......
×î½üÏÂÃæ·´Ó¦Ëµ³ÌÐòÒì³£
È»ºó´ò¿ªÊý¾Ý¿âÒ»¿´
·¢Ïֺܶà±í¶¼"Ö»¶Á"״̬??
ÓÃsaµÇ½ҲÊÇ...
ºÜÆæ¹Ö°¡..
´óÅ£ÖªµÀÊÇʲôÔÒòÂð?
Ô¸Òâ³ö¸ß·ÖÇó
˽â¾öÁË
¸ø200·Ö!!
Êý¾Ý¿â³öÎÊÌâÁË?
ÒýÓÃ
×î½üÏÂÃæ ......
ÒªÇóÄÜʵÏÖ¶þÈËÔŲ́ͬµçÄÔÉ϶ÔÕ½µÄ ²»ÓÃÌ«»¨ÉÚ ×îºÃ»¹¼ÓÉÏÈË»ú¶ÔÕ½µÄ ¼±Ðè ˰ïÏÂæ°¡Ñ½!!!!!!!!
up
baidu£¬google
up
http://www.codepub.com/software/view-software-4061.html
ÍøÕ¾ÉÏÓÐ
......
ÔÚvbscriptÖв»ÓÃon error resume nextÈçºÎÅжÏmssqlÓï·¨´íÎó£¡
TRY CATCH?
»òÕßʹÓÃÁ÷³Ì¿ØÖÆÓï¾ä
if
else
²»ÓÃon error ÓÃÄǸöÎҾͲ»ÐèÒªÔÚÕâÀïѰÕÒ´ð°¸
ÒýÓÃ
²»ÓÃon error ÓÃÄǸöÎҾͲ»Ðè ......
ÎÒÔõô²éÁËÄÇô¶à˵ÊÇÄÜÆÆ½âµÄ£®½á¹û¶¼²»ÐУ®ÄãÃÇÓÐûÓÐѽ£®¸øÎÒ¸öÏêϸµÄ½â¾ö·½°¸£®ÏÂÔØÄĸö°æ±¾£®ÆÆ½âÎļþ£¬»¹ÓÐ×¢²áÂë
²»Çå³þ
ÏÂÔØ¹Ù·½¹âÅ̾µÏñ£¬ÓÃdelphidistiller1.85ÆÆ½â
µ½www.2ccc.comÉÏÈ¥ÕÒdelphidis ......