ÓαêÊôÐÔSQL%FOUND,SQL%NOTFOUND,SQL%ROWCOUNT
¡¡¡¡µ±Ö´ÐÐÒ»ÌõDMLÓï¾äºó£¬DMLÓï¾äµÄ½á¹û±£´æÔÚËĸöÓαêÊôÐÔÖУ¬ÕâЩÊôÐÔÓÃÓÚ¿ØÖƳÌÐòÁ÷³Ì»òÕßÁ˽â³ÌÐòµÄ״̬¡£µ±ÔËÐÐDMLÓï¾äʱ£¬PL/SQL´ò¿ªÒ»¸öÄÚ½¨Óα겢´¦Àí½á¹û£¬ÓαêÊÇά»¤²éѯ½á¹ûµÄÄÚ´æÖеÄÒ»¸öÇøÓò£¬ÓαêÔÚÔËÐÐDMLÓï¾äʱ´ò¿ª£¬Íê³Éºó¹Ø±Õ¡£ÒþʽÓαêֻʹÓÃSQL%FOUND,SQL%NOTFOUND,SQL%ROWCOUNTÈý¸öÊôÐÔ.SQL%FOUND,SQL%NOTFOUNDÊDz¼¶ûÖµ£¬SQL%ROWCOUNTÊÇÕûÊýÖµ¡£
¡¡¡¡SQL%FOUNDºÍSQL%NOTFOUND
¡¡¡¡ÔÚÖ´ÐÐÈκÎDMLÓï¾äÇ°SQL%FOUNDºÍSQL%NOTFOUNDµÄÖµ¶¼ÊÇNULL,ÔÚÖ´ÐÐDMLÓï¾äºó£¬SQL%FOUNDµÄÊôÐÔÖµ½«ÊÇ£º
¡¡¡¡. TRUE :INSERT
¡¡¡¡. TRUE :DELETEºÍUPDATE£¬ÖÁÉÙÓÐÒ»Ðб»DELETE»òUPDATE.
¡¡¡¡. TRUE :SELECT INTOÖÁÉÙ·µ»ØÒ»ÐÐ
¡¡¡¡µ±SQL%FOUNDΪTRUEʱ,SQL%NOTFOUNDΪFALSE¡£
¡¡¡¡SQL%ROWCOUNT
¡¡¡¡ÔÚÖ´ÐÐÈκÎDMLÓï¾ä֮ǰ£¬SQL%ROWCOUNTµÄÖµ¶¼ÊÇNULL,¶ÔÓÚSELECT INTOÓï¾ä£¬Èç¹ûÖ´Ðгɹ¦£¬SQL%ROWCOUNTµÄֵΪ1,Èç¹ûûÓгɹ¦£¬SQL%ROWCOUNTµÄֵΪ0£¬Í¬Ê±²úÉúÒ»¸öÒì³£NO_DATA_FOUND.
¡¡¡¡SQL%ISOPEN
¡¡¡¡SQL%ISOPENÊÇÒ»¸ö²¼¶ûÖµ£¬Èç¹ûÓαê´ò¿ª£¬ÔòΪTRUE, Èç¹ûÓαê¹Ø±Õ£¬ÔòΪFALSE.¶ÔÓÚÒþʽÓαê¶øÑÔSQL%ISOPEN×ÜÊÇFALSE£¬ÕâÊÇÒòΪÒþʽÓαêÔÚDMLÓï¾äÖ´ÐÐʱ´ò¿ª£¬½áÊøʱ¾ÍÁ¢¼´¹Ø±Õ¡£
Ïà¹ØÎĵµ£º
Student(S#,Sname,Sage,Ssex) ѧÉú±í
Course(C#,Cname,T#) ¿Î³Ì±í
SC(S#,C#,score) ³É¼¨±í
Teacher(T#,Tname) ½Ìʦ±í
ÎÊÌ⣺
1¡¢²éѯ“001”¿Î³Ì±È“002”¿Î³Ì³É¼¨¸ßµÄËùÓÐѧÉúµÄѧºÅ£»
select a.S# from (select s#,score from SC where C#='001') a,(select s#,score
fr ......
ÎÊÌâÃèÊö£º
±¾ÌâÓõ½ÏÂÃæÈý¸ö¹Øϵ±í£º
CARD ½èÊ鿨¡£ CNO ¿¨ºÅ£¬NAME ÐÕÃû£¬CLASS °à¼¶
BOOKS ͼÊé¡£ BNO ÊéºÅ£¬BNAME ÊéÃû,AUTHOR ×÷Õߣ¬PRICE µ¥¼Û£¬QUANTITY ¿â´æ²áÊý
BORROW ½èÊé¼Ç¼¡£ CNO ½èÊ鿨ºÅ£¬BNO ÊéºÅ ......
ÔÚ×ö¹ýµÄºÜ¶àÏîÄ¿ÖУ¬·¢ÏÖ´ó¼Ò²»¹Ü¶Ôʲô±í£¬·êselect±Ø¶¨¼ÓÉÏnolock£¨»òÕßwith£¨nolock£©£©£¬ºÃÏñÒѾÊÇÖƶȻ¯µÄÒ»ÖÖ¶«Î÷¡£ÓÐÁìµ¼¸ßÈ˽âÊÍ˵¼ÓÉÏnolock¿ÉÒÔÌá¸ß²éѯËٶȣ¬²»Ó°Ïì¶ÔÊý¾Ý±íµÄÆäËû²¢·¢²Ù×÷¡£
¡¡¡¡µ«ÊÇÕæÓбØҪÿ¸ö²éѯ¶¼¼ÓnolockÂ𣿸öÈËÈÏΪ¼Ó²»¼Ónolock»¹ÊÇÖµµÃÎÒÃǸù¾Ýʵ¼ÊÇé¿öÕå×ÃÒ»·¬µÄ£¨ÖÁ ......
ºØÖÝÊм²²¡Ô¤·À¿ØÖÆÖÐÐÄËùÓõÄZmSoft´ÓÒµÌå¼ìÐÅÏ¢ÍøÂçϵͳV2010.1.26 Õýʽ°æ²ÉÓÃSQL SERVER2000ƽ̨,²»Ã÷ÔÒò,Êý¾Ý¿â"ÖÃÒÉ“,¿Í»§ÊÔ¹ýËùÓÐÍøÉÏ·½·¨,δÄܽâ¾ö.ÉòÑô¿ÎÄÊý¾Ý»Ö¸´ÖÐÐÄSQLÊý¾Ý¿â¹¤³Ìʦ³É¹¦½«Æä½â¾ö.
ÉòÑô¿ÎÄÊý¾Ý»Ö¸´ÖÐÐÄMS SQL SERVERÑз¢Ð¡×éÖÂÁ¦ÓÚMsSqlÊý¾Ý¿â¼¼ÊõµÄÑо¿¡£¾¹ý¶àÄêÑо¿ÍêÈ«ÕÆÎÕÁËS ......
½«Ä³ÖÖÊý¾ÝÀàÐ͵ıí´ïʽÏÔʽת»»ÎªÁíÒ»ÖÖÊý¾ÝÀàÐÍ¡£CAST ºÍ CONVERT ÌṩÏàËƵŦÄÜ¡£
Óï·¨
ʹÓà CAST£º
CAST ( expression AS data_type )
ʹÓà CONVERT£º
CONVERT (data_type[(length)], expression [, style])
²ÎÊý
expression
ÊÇÈκÎÓÐЧµÄ Microsoft® SQL Server™ ±í´ïʽ¡£Óйظü¶àÐÅÏ¢£¬Çë² ......