SQLSERVER SQLÐÔÄÜÓÅ»¯
1.Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)¡¡¡¡
¡¡¡¡ SQLSERVERµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬Òò´Ëfrom×Ó¾äÖÐдÔÚ×îºóµÄ±í£¨»ù´¡±ídriving table£©½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏ£¬±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í£¬µ±SQLSERVER´¦Àí¶à¸ö±íʱ£¬»áÔËÓÃÅÅÐò¼°ºÏ²¢µÄ·½Ê½Á¬½ÓËüÃÇ£¬
¡¡¡¡ Ê×ÏÈ£¬É¨ÃèµÚÒ»¸ö±í£¨from×Ó¾äÖÐ×îºóµÄÄǸö±í)²¢¶Ô¼Ç¼½øÐÐÅÅÐò£»È»ºóɨÃèµÚ¶þ¸ö±í£¨from×Ó¾äÖÐ×îºóµÚ¶þ¸ö±í)£»×îºó½«ËùÓдӵڶþ¸ö±íÖмìË÷³öµÄ¼Ç¼ÓëµÚÒ»¸ö±íÖкÏÊʼǼ½øÐкϲ¢
¡¡¡¡ ÀýÈç: ±í TAB1 16,384 Ìõ¼Ç¼±í TAB2 5 Ìõ¼Ç¼£¬Ñ¡ÔñTAB2×÷Ϊ»ù´¡±í (×îºÃµÄ·½·¨) select count(*) from tab1,tab2 Ö´ÐÐʱ¼ä0.96Ã룬ѡÔñTAB2×÷Ϊ»ù´¡±í (²»¼ÑµÄ·½·¨) select count(*) from tab2,tab1 Ö´ÐÐʱ¼ä26.09Ã룻
Èç¹ûÓÐ3¸öÒÔÉϵıíÁ¬½Ó²éѯ£¬ÄǾÍÐèҪѡÔñ½»²æ±í£¨intersection table£©×÷Ϊ»ù´¡±í£¬½»²æ±íÊÇÖ¸ÄǸö±»ÆäËû±íËùÒýÓÃµÄ±í¡¡¡¡
¡¡¡¡ ÀýÈç:
¡¡¡¡ EMP±íÃèÊöÁËLOCATION±íºÍCATEGORY±íµÄ½»¼¯
¡¡¡¡ SELECT *
¡¡¡¡ from LOCATION L,
¡¡¡¡ CATEGORY C,
¡¡¡¡ EMP E
¡¡¡¡ WHERE E.EMP_NO BETWEEN 1000 AND 2000
¡¡¡¡ AND E.CAT_NO = C.CAT_NO
¡¡¡¡ AND E.LOCN = L.LOCN
¡¡¡¡
¡¡¡¡ ½«±ÈÏÂÁÐSQL¸üÓÐЧÂÊ
¡¡¡¡ SELECT *
¡¡¡¡ from EMP E ,
¡¡¡¡ LOCATION L ,
¡¡¡¡ CATEGORY C
¡¡¡¡ WHERE E.CAT_NO = C.CAT_NO
¡¡¡¡ AND E.LOCN = L.LOCN
¡¡¡¡ AND E.EMP_NO BETWEEN 1000 AND 2000
¡¡¡¡
¡¡¡¡ 2.WHERE×Ó¾äÖеÄÁ¬½Ó˳Ðò¡¡¡¡
¡¡¡¡ SQLSERVER²ÉÓÃ×Ô϶øÉϵÄ˳Ðò½âÎöWHERE×Ӿ䣬¸ù¾ÝÕâ¸öÔÀí£¬±íÖ®¼äµÄÁ¬½Ó±ØÐëдÔÚÆäËûWHEREÌõ¼þ֮ǰ£¬ÄÇЩ¿ÉÒÔ¹ýÂ˵ô×î´óÊýÁ¿¼Ç¼µÄÌõ¼þ±ØÐëдÔÚWHERE×Ó¾äµÄĩβ¡¡¡¡
¡¡¡¡ ÀýÈ磺
¡¡¡¡ (µÍЧ,Ö´ÐÐʱ¼ä156.3Ãë)
¡¡¡¡ SELECT *
¡¡¡¡ from EMP E
¡¡¡¡ WHERE SAL > 50000
¡¡¡¡ AND JOB = 'MANAGER'
¡¡¡¡ AND 25 < (SELECT COUNT(*) from EMP WHERE MGR=E.EMPNO);¡¡¡¡
¡¡¡¡ (¸ßЧ,Ö´ÐÐʱ¼ä10.6Ãë)
¡¡¡¡ SELECT *
¡¡¡¡ from EMP E
¡¡¡¡ WHERE 25 < (SELECT COUNT(*) from EMP WHERE MGR=E.EMPNO)
¡¡¡¡ AND SAL > 50000
¡¡¡¡ AND JOB = 'MANAGER';
¡¡¡¡
¡¡¡¡ 3.SELECT×Ó¾äÖбÜÃâʹÓÃ'*'¡£µ±ÄãÏëÔÚSELECT×Ó¾äÖÐÁгöËùÓеÄCOLUMNʱ£¬Ê¹Óö¯Ì¬SQLÁÐÒýÓÃ'*'ÊÇÒ»¸ö·½±ãµÄ·½·¨£¬²»ÐÒµÄÊÇ£¬ÕâÊÇÒ»¸ö·Ç³£µÍЧµÄ·½·¨¡£Êµ¼ÊÉÏ£¬
Ïà¹ØÎĵµ£º
sqlserver2005Ô¶³ÌÁ¬½Ó mysql
2ÖÖ·½·¨
Ò»ÊÇͨ¹ý½¨Á¢linkµÄ·½·¨
sp_addlinkedserver 'ntest-linkÃû', 'MySQL', 'MSDASQL--Ö§³ÖµÄÁ´½Ó·½Ê½', 'mytest-dsnÃû'
GO
sp_addlinkedsrvlogin 'ntest-linkÃû','false', 'sa-sqlserverÓû§','mythzz-sqlserverÃÜÂë' ......
character-set-server = GB2312
collation-server = latin1_general_ci
MySQL×Ö·û¼¯ GBK¡¢GB2312¡¢UTF8Çø±ð ½â¾ö MYSQLÖÐÎÄÂÒÂëÎÊÌâ ÊÕ²Ø
MySQLÖÐÉæ¼°µÄ¼¸¸ö×Ö·û¼¯
character-set-server/default-character-set£º·þÎñÆ÷×Ö·û¼¯£¬Ä¬ÈÏÇé¿öÏÂËù²ÉÓõġ£
character-set-database£ºÊý¾Ý¿â×Ö·û¼¯¡£
character-set-table£ºÊ ......
ÊìϤSQL SERVER 2000µÄÊý¾Ý¿â¹ÜÀíÔ±¶¼ÖªµÀ£¬ÆäDTS¿ÉÒÔ½øÐÐÊý¾ÝµÄµ¼Èëµ¼³ö£¬Æäʵ£¬ÎÒÃÇÒ²¿ÉÒÔʹÓÃTransact-SQLÓï¾ä½øÐе¼Èëµ¼³ö²Ù×÷¡£ÔÚTransact-SQLÓï¾äÖУ¬ÎÒÃÇÖ÷ҪʹÓÃOpenDataSourceº¯Êý¡¢OPENROWSET º¯Êý£¬¹ØÓÚº¯ÊýµÄÏêϸ˵Ã÷£¬Çë²Î¿¼SQLÁª»ú°ïÖú¡£ÀûÓÃÏÂÊö·½·¨£¬¿ÉÒÔÊ®·ÖÈÝÒ×µØÊµÏÖSQL SERVER¡¢ACCESS¡¢EXCELÊý¾Ýת»»£ ......
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 ......
±¾ÎÄÀ´×ÔCSDN²©¿Í£¬×ªÔØÇë±êÃ÷³ö´¦£ºhttp://blog.csdn.net/yf520gn/archive/2008/09/26/2982363.aspx
SELECT * from TB_MILES_CB_ORDER
WHERE convert(varchar(100),ORDER_DATE,102)= £¿
ORDER BY ORDER_NO
SELECT CONVERT(varchar(100), GETDATE(), 0): 05 16 2006 10:57AM
SELECT CONVERT(varchar(100), GETDATE ......