sqlÓï¾äÓÅ»¯3
µÍЧ: (Ë÷ÒýʧЧ)
SELECT … from DEPARTMENT WHERE DEPT_CODE IS NOT NULL;
¸ßЧ: (Ë÷ÒýÓÐЧ)
SELECT … from DEPARTMENT WHERE DEPT_CODE >=0;
£¨27£©×ÜÊÇʹÓÃË÷ÒýµÄµÚÒ»¸öÁУº
Èç¹ûË÷ÒýÊǽ¨Á¢ÔÚ¶à¸öÁÐÉÏ, Ö»ÓÐÔÚËüµÄµÚÒ»¸öÁÐ(leading column)±»where×Ó¾äÒýÓÃʱ,ÓÅ»¯Æ÷²Å»áÑ¡ÔñʹÓøÃË÷Òý¡£ÕâÒ²ÊÇÒ»Ìõ¼òµ¥¶øÖØÒªµÄ¹æÔò£¬µ±½öÒýÓÃË÷ÒýµÄµÚ¶þ¸öÁÐʱ,ÓÅ»¯Æ÷ʹÓÃÁËÈ«±íɨÃè¶øºöÂÔÁËË÷Òý¡£
£¨28£©ÓÃUNION-ALL Ìæ»»UNION ( Èç¹ûÓпÉÄܵϰ)£º
µ±SQLÓï¾äÐèÒªUNIONÁ½¸ö²éѯ½á¹û¼¯ºÏʱ,ÕâÁ½¸ö½á¹û¼¯ºÏ»áÒÔUNION-ALLµÄ·½Ê½±»ºÏ²¢, È»ºóÔÚÊä³ö×îÖÕ½á¹ûǰ½øÐÐÅÅÐò¡£Èç¹ûÓÃUNION ALLÌæ´úUNION,http://www.vstudycn.com ÕâÑùÅÅÐò¾Í²»ÊDZØÒªÁË¡£Ð§ÂʾͻáÒò´ËµÃµ½Ìá¸ß¡£ÐèҪעÒâµÄÊÇ£¬UNION ALL ½«Öظ´Êä³öÁ½¸ö½á¹û¼¯ºÏÖÐÏàͬ¼Ç¼¡£Òò´Ë¸÷λ»¹ÊÇÒª´ÓÒµÎñÐèÇó·ÖÎöʹÓÃUNION ALLµÄ¿ÉÐÐÐÔ. UNION ½«¶Ô½á¹û¼¯ºÏÅÅÐò,Õâ¸ö²Ù×÷»áʹÓõ½SORT_AREA_SIZEÕâ¿éÄÚ´æ¡£¶ÔÓÚÕâ¿éÄÚ´æµÄÓÅ»¯Ò²ÊÇÏàµ±ÖØÒªµÄ¡£ÏÂÃæµÄSQL¿ÉÒÔÓÃÀ´²éѯÅÅÐòµÄÏûºÄÁ¿£º
µÍЧ£º
SELECT ACCT_NUM, BALANCE_AMT
from DEBIT_TRANSACTIONS
WHERE TRAN_DATE = '31-DEC-95'
UNION
SELECT ACCT_NUM, BALANCE_AMT
from DEBIT_TRANSACTIONS
WHERE TRAN_DATE = '31-DEC-95'
¸ßЧ:
SELECT ACCT_NUM, BALANCE_AMT
from DEBIT_TRANSACTIONS
WHERE TRAN_DATE = '31-DEC-95'
UNION ALL
SELECT ACCT_NUM, BALANCE_AMT
from DEBIT_TRANSACTIONS
WHERE TRAN_DATE = '31-DEC-95'
£¨29£©ÓÃWHEREÌæ´úORDER BY£º
ORDER BY ×Ó¾äÖ»ÔÚÁ½ÖÖÑϸñµÄÌõ¼þÏÂʹÓÃË÷Òý¡£
ORDER BYÖÐËùÓеÄÁбØÐë°üº¬ÔÚÏàͬµÄË÷ÒýÖв¢±£³ÖÔÚË÷ÒýÖеÄÅÅÁÐ˳Ðò¡£
ORDER BYÖÐËùÓеÄÁбØÐ붨ÒåΪ·Ç¿Õ¡£
WHERE×Ó¾äʹÓõÄË÷ÒýºÍORDER BY×Ó¾äÖÐËùʹÓõÄË÷Òý²»Äܲ¢ÁС£
ÀýÈç: ±íDEPT°üº¬ÒÔÏÂÁÐ:
DEPT_CODE PK NOT NULL
DEPT_DESC NOT NULL
DEPT_TYPE NULL
µÍЧ: (Ë÷Òý²»±»Ê¹ÓÃ)
SELECT DEPT_CODE&n
Ïà¹ØÎĵµ£º
http://www.umgr.com/blog/PostView.aspx?bpId=36294
1. Ö´ÐÐsqlÓï¾ä
int sqlite3_exec(sqlite3*£¬ const char *sql£¬ sqlite3_callbacksql Óï·¨
£¬ void *£¬ char **errmsg );
Õâ¾ÍÊÇÖ´ÐÐÒ»Ìõ sql Óï¾äµÄº¯Êý¡£
µÚ1¸ö²ÎÊý²»ÔÙ˵ÁË£¬ÊÇÇ°Ãæopenº¯ÊýµÃµ½µÄÖ¸Õ롣˵ÁËÊǹؼüÊý¾Ý½á¹¹¡£
µÚ2¸ö²ÎÊýconst char ......
1.Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)¡¡¡¡
¡¡¡¡ SQLSERVERµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬Òò´Ëfrom×Ó¾äÖÐдÔÚ×îºóµÄ±í£¨»ù´¡±ídriving table£©½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏ£¬±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í£¬µ±SQLSERVER´¦Àí¶à¸ö±íʱ£¬»áÔËÓÃÅÅÐò¼°ºÏ²¢µÄ·½Ê½Á ......
ÔÚȡһ¸öƽ¾ùÖµµÄʱºòÍùÍùÓöµ½Ð¡ÊýµãλÊýµÄ½ØÈ¡¡£
ǰ¼¸ÌìÓöµ½¹ýÕâô¸öÎÊÌ⣬ÔÚKingDee EAS µÄ²éѯ·ÖÎöÆ÷ÀïÃæÈç¹ûÇóijһÎïÁÏµÄÆ½¾ùµ¥¼ÛʱÎÒÕâÑùдµÀ£º
select avg = case sum(bentry.FQuantity) when 0 then 0 else (sum(bentry.famount)/sum(bentry.FQuantity)) end,
´ËÓï¾ä¿´ËÆÃ»Ê²Ã´ÎÊÌ⣬±Ï¾¹ÊÇÇ󯽾ùÖµ£¬¿ÉÊÇÈç¹ûÒªÔ ......
ÎÊÌâ
¡¡¡¡µ±sql serverÆô¶¯Ê±£¬ÎÒºÜÏëÔËÐÐÒ»¸ö´æ´¢¹ý³Ì¡£ÓÐûÓÐÒ»ÖÖ·½·¨¿ÉÒÔÔÚÿ´ÎSQL Server·þÎñÆô¶¯Ê±¶¼»á×Ô¶¯Ö´ÐÐÕâ¸ö´æ´¢¹ý³ÌÄØ?
¡¡¡¡×¨¼Ò½â´ð
¡¡¡¡sql ServerÌṩÁËϵͳ´æ´¢¹ý³Ìsp_procoption£¬Õâ¸ö´æ´¢¹ý³Ì¿ÉÒÔÓÃÓÚµ±SQL Server·þÎñÆô¶¯Ê±Ö¸ÅÉÒ»¸ö»òÕß¶à¸ö´æ´¢¹ý³Ì×Ô¶¯Ö´ÐС£ÕâÊÇÒ»¸öºÜ²»´íµÄÑ¡Ôñ£¬Ëü¿ÉÒÔÓÃÓÚ¶àÖÖ ......
1 :ÆÕͨSQLÓï¾ä¿ÉÒÔÓÃExecÖ´ÐÐ
Àý: Select * from tableName
Exec('select * from tableName')
& ......