PL/SQLÓαê×ܽá
Óα꣺ָÏò´¦ÀíSQLÓï¾äµÄ»·¾³ÇøÓòµÄÖ¸Õë»ò¾ä±ú
-----|-1 ¾²Ì¬Óαê
|---1.1 ÒþʽÓαê
| ´¦Àí£ºINSERT,DELETE,UPDATE¼°·µ»ØÒ»ÐеÄSELECTÓï¾ä
| ²Ù×÷£ºÓÉPL/SQL×Ô¶¯¶¨Òå²¢Íê³É´ò¿ªÓë¹Ø±Õ¶¯×÷
| ÊôÐÔ£º%FOUND,%NOTFOUND,%ISOPEN,%ROWCOUNT
|---1.2 ÏÔʾÓαê
| ´¦Àí£º·µ»Ø¶àÐеÄSELECTÓï¾ä
| ²Ù×÷£º1.2.1 ÏÔÊ¾ÍÆ½øÑ»·
| --ÉùÃ÷Óαê
| --´ò¿ªÓαê
| --ÍÆ½øÓαê
| --¹Ø±ÕÓαê
| 1.2.2 ×Ô¶¯ÍƽøÑ»·
|
Ïà¹ØÎĵµ£º
²âÊÔ»útest°²×°µÄÊÇwindows server2008+sql server 2008£¬Êý¾Ý¿â°²×°³É¹¦¡£¿ÉÒÔÁ¬½Ó¾ÖÓòÍøÄÚÆäËû»úÆ÷µÄÊý¾Ý¿â£¨ÆäËû»úÆ÷µÄÊý¾Ý¿âΪSQL 2005£©¡£µ«ÊÇÍøÄÚÆäËû»úÆ÷·ÃÎÊtestʱ£¬ÎÞ·¨Á¬½Ó£¬±¨´í¡£ÐÅϢΪ£ºÔÚ½¨Á¢Óë·þÎñÆ÷µÄÁ¬½Óʱ³ö´í¡£ÔÚÁ¬½Óµ½SQL SERVER 2005ʱ£¬ÔÚĬÈϵÄÉèÖÃÏÂSQL SERVER ²»ÔÊÐí½øÐÐÔ¶³ÌÁ¬½Ó¿ÉÄܻᵼÖ´Îʧ°Ü ......
Ò»¡¢ÎÊÌâ
select UserID,LastName,FirstName,UserName from SYSUser
UserID LastName FirstName UserName
------------------------------------------------------
1 A B C
2 &nb ......
(1)Êý¾Ý¼Ç¼ɸѡ£º
sql="select*fromÊý¾Ý±íwhere×Ö¶ÎÃû=×Ö¶ÎÖµorderby×Ö¶ÎÃû[desc]"
sql="select*fromÊý¾Ý±íwhere×Ö¶ÎÃûlike'%×Ö¶ÎÖµ%'orderby×Ö¶ÎÃû[desc]"
sql="selecttop10*fromÊý¾Ý±íwhere×Ö¶ÎÃûorderby×Ö¶ÎÃû[desc]"
sql="select*fromÊý¾Ý±íwhere×Ö¶ÎÃûin('Öµ1','Öµ2','Öµ3')"
sql="select*fromÊý¾Ý±íwhere× ......
ÎÒÀí½âµÄSQL Server 2005¾µÏñÅäÖÃʵ¼ÊÉϾÍÊÇÓÉÈý¸ö·þÎñÆ÷£¨Ò²¿ÉÒÔÊÇͬһ·þÎñÆ÷µÄÈý¸ö SQL ʵÀý£©×é³ÉµÄÒ»¸ö±£Ö¤Êý¾ÝµÄ»·¾³£¬·Ö±ðÊÇ£ºÖ÷·þÎñÆ÷¡¢´Ó·þÎñÆ÷¡¢¼ûÖ¤·þÎñÆ÷¡£
Ö÷·þÎñÆ÷£ºÊý¾Ý´æ·ÅµÄµØ·½
´Ó·þÎñÆ÷£ºÊý¾Ý±¸·ÝµÄµØ·½£¨¼´£ºÖ÷·þÎñÆ÷µÄ¾µÏñ£©
¼ûÖ¤·þÎñÆ÷£º¶¯Ì¬µ÷ÅäÖ÷/´Ó·þÎñÆ÷µÄµÚÈý·½·þÎñÆ÷
»·¾³½éÉÜ
Ê×ÏȽé ......