µÚ10Õ£ºSQLºÍTQuery¶ÔÏó
±¾ÕÂÊǹØÓÚ²éѯ¡£ÕâÊÇÒ»¸öÖ÷Ì⣬ÔÚºËÐĵĿͻ§/·þÎñÆ÷±à³Ì£¬Òò´ËÕâÊDZ¾Êé¸üÖØÒªµÄƪÕÂÖ®Ò»¡£
¸Ã²ÄÁϽ«±»·Ö³ÉÒÔÏÂÖ÷Òª²¿·Ö£º
ʹÓÃTQuery¶ÔÏó
ʹÓñ¾µØºÍÔ¶³Ì·þÎñÆ÷µÄSQLÀ´Ñ¡Ôñ£¬¸üУ¬É¾³ýºÍ²åÈë¼Ç¼
ʹÓÃSQLÓï¾äÀ´´´½¨Á¬½Ó£¬ÁªÏµÓαêºÍ³ÌÐò£¬ËÑË÷µ¥¸ö¼Ç¼
Õâ¸öËõд´ú±íµÄSQL½á¹¹»¯²éѯÓïÑÔ£¬Í¨³£ÊÇÃ÷ÏÔµÄÐø¼¯»ò˵ÿ·âÐÅ£¨¹ðÁÖ£¬ãÚÈø¶ûÍ߶ࣩ¡£ÎÞÂÛÔõÑùÑ¡ÔñÅд¦ËÀÐÌ£¬ÊÇÒ»¸ö¹¦ÄÜÇ¿´óµÄSQLÊý¾Ý¿âÓïÑÔ£¬ºÜÈÝÒ×´ÓÄÚ²¿BCB·ÃÎÊ£¬¶øÊÇ´ÓBCBµÄĸÓﲻͬ¡£ BCB¿ÉÒÔʹÓÃSQLÓï¾ä´ÓÊý¾Ý¿âÖмìË÷±í£¬Ö´ÐбíÖ®¼äµÄÁª½Ó£¬½¨Á¢Ò»¸ö¶ÔÐí¶à¹Øϵ»òÒªÇ󼸺õËùÓй¦ÄÜ£¬ÄúµÄ·þÎñÆ÷¿ÉÒÔÌṩ¡£
ÓëÁ½¸öSQLÒýÇ棬BCB´¬Ö»½øÈëÓëã£ÂÛºÍdBASEʹÓÃä廯Ð˽¨£¬ºÍÆäËû½¨³ÉInterBase¡£´ËÍ⣬Äú»¹¿ÉÒÔ·ÃÎÊ£¬ÈçMS SQL ServerÖУ¬Èü±´Ë¹£¬¼×¹ÇÎÄ£¬DB2ºÍInformixµÄÆäËûSQLÊý¾Ý¿â¡£×÷ΪһÏî¹æÔò£¬IBµÄSQLÒýÇæ¸üÇ¿´ó±ÈΪParadox»òdBASE±íÐ˽¨µÄÖ®Ò»£¬µ«ËüÃǶ¼Ìṩ¹ã·ºµÄ·þÎñ¡£¹Ø¼üµÄÒ»µã£¬È»¶ø£¬Äú¿ÉÒÔÖ´ÐÐSQL²éѯ£¬¼´Ê¹ÄãÊÇÔÚÒ»¸ö¶ÀÁ¢¹¤×÷£¬¶ÀÁ¢µÄ»úÆ÷£¬²»¾ßÓзÃÎÊ·þÎñÆ÷¡£
BCBÌṩ֧³Öͨ¹ýSQLÖУ¬ÕâÒâζ×ÅÄã¿ÉÒÔ׫дSQLÓï¾ä£¬È»ºóÈÃËûÃÇÖ±½ÓË͵½£¨ÓëÒ»¸ö»òÁ½¸öÀýÍ⣩µ½Oracle£¬Sybase¹«Ë¾InterBase£¬»òÆäËû·þÎñÆ÷¡£Í¨¹ýSQLµÄÊÇÒ»¸öÇ¿´óµÄ¹¦ÄÜ£¬ÔÒòÓжþ£º
1¡£´ó¶àÊý·þÎñÆ÷µÄSQLÓï¾ä¿ÉÒÔ´¦Àí·Ç³£Ñ¸ËÙ£¬ÕâÒâζ×ÅÄú¿ÉÒÔʹÓÃÔ¶³ÌÊý¾ÝµÄSQLÒÔ»ñµÃÁ˼«¿ìµÄÏìÓ¦ÄúµÄÇëÇó¡£
2¡£Äú¿ÉÒÔ׫дSQLÓï¾äµÄÒªÇóÀ´Ö´ÐзþÎñÆ÷ͨ¹ýBCBµÄĸÓïÓÃרÃÅÈÎÎñ¡£
ÔÚ×îºóÒ»Õ£¬Äãѧµ½ÁËÈçºÎBCBÄÚ²¿¹¤×÷£¬ÒÔ¼°ÈçºÎÀûÓÃÆä±¾ÍÁµÄÄÜÁ¦ºÜ¶à¡£ÏÖÔÚÊÇʱºò¿´¿´BCBÓëÊý¾Ý¿â½»»¥µÄ¹¤¾ß£¬Ä¿Ç°´æÔÚÓÚÄúµÄ¼ÆËã»ú»òÍøÂçÉϵÄÈκΡ£
Èç¹ûÄúÒÔÇ°´ÓδʹÓÃTQuery¶ÔÏó֮ǰ£¬ÄãÓ¦¸Ã¼ìÌÖÏÖÐеĿØÖÆÌõ£¬µÚ8ÕÂÖУ¬“Êý¾Ý¿â»ù´¡ÖªÊ¶ºÍÊý¾Ý¿â¹¤¾ß”£¬Ëü¸ø³öÁËËùÓлù±¾ÔÚBCBÖеÄÊý¾Ý¿â¹¤¾ßµÄ¸ÅÊö¡£±¾ÕµÄÖصãÊÇÄÇЩ¹¤¾ßÖ®Ò»- TQuery -²¢ËµÃ÷ËüÔÚÒ»¶¨µÄÉî¶È¡£
±¾Õ²»ÄâÒ»¸öSQLµ×Æᣬ¶øÊÇÐðÊöµÄTQuery¶ÔÏóºÍ»ù±¾ÈÎÎñ£¬Äú¿ÉÒÔÖ´ÐÐËü¡£¼´Ê¹Äã²»ÖªµÀÈκÎÓйØSQL£¬±¾ÕÂÈÔÈ»»á°ïÖúÄ㣬Äã×îÖÕѧϰ¹ØÓÚÈçºÎ׫дһ¸öSQLÓï¾äµÄ»ù±¾ÊÂʵµÄ˵·¨¡£µ«ÊÇ£¬¶ÔÓÚÓïÑÔµÄÏêϸ·ÖÎö£¬ÄãÓ¦¸Ã°ÑÒ»¸öÐí¶àÊé¼®ºÍÓйØÕâÒ»ÒéÌâµÄ¹«¿ªÎļþ¡£¾ÙÀýÀ´Ëµ£¬ÎÒÆ«ÏòÓÚʵÓõÄSQLÊֲᣬ±«ÂüµÈ£¬°¬µÏÉúΤ˹Àû¡£ÄúÒ²¿ÉÒԲο¼ÔÚΪWISQL UtilityµÄÁª»ú°ïÖú²Î¿¼×ÊÁÏ¡£¸ü¶àÐÅÏ¢£¬¿ÉÔÚ1 LOCALSQL.HLPÎļþµÄÐÎʽ£¬ÓÃBCB´¬Ö»¡£ £¨¿ª·ÅµÄ°ïÖúÏ£¬°´ALT + F +°Ä£¬È»ºóÑ¡
Ïà¹ØÎĵµ£º
£¨18£©ÓÃEXISTSÌæ»»DISTINCT£º
µ±Ìá½»Ò»¸ö°üº¬Ò»¶Ô¶à±íÐÅÏ¢(±ÈÈ粿ÃűíºÍ¹ÍÔ±±í)µÄ²éѯʱ,±ÜÃâÔÚSELECT×Ó¾äÖÐʹÓÃDISTINCT¡£Ò»°ã¿ÉÒÔ¿¼ÂÇÓÃEXISTÌæ»», EXISTS ʹ²éѯ¸üΪѸËÙ,ÒòΪRDBMSºËÐÄÄ£¿é½«ÔÚ×Ó²éѯµÄÌõ¼þÒ»µ©Âú×ãºó,Á¢¿Ì·µ»Ø½á¹û¡£Àý×Ó£º
(µÍЧ):
SELECT DISTINCT DEPT_NO,DEPT_NAME  ......
thunder:
1.MYSQLʵÏÖ
mysql> select * from user;
+----+----------+----------+-----------------+
| ID | username | password | email |
+----+----------+----------+-----------------+
| 1 | admin | admin &nb ......
l INNER JOIN
ÄÚÁ¬½ÓÊÇ×î³£¼ûµÄÒ»ÖÖÁ¬½Ó£¬ËüÒ³±»³ÆΪÆÕͨÁ¬½Ó£¬¶øE.FCodd×îÔç³Æ֮Ϊ×ÔÈ»Á¬½Ó¡£
ÏÂÃæÊÇANSI SQL£92±ê×¼
select * from t_institution i
inner join t_teller t
on i.inst_no = t.inst_no //˵Á½¸ö±íÖ®¼äµÄ¹ØϵÓÃON
where i.inst_no = "5801"
ÆäÖÐinner¿ÉÒÔÊ¡Â ......
ÔÚÍøÉÏ¿´µ½SQL×Ö·û´®×ª16½øÖƵÄÓï¾ä£¬¾¹ýССÌí¼Ó£¬ÏÖ½«SQL×Ö·û´®Óë16½øÖÆ»¥»»µÄ·½·¨¼Ç¼£¬ÒÔ¹©ÒÔºó²é¿´¡£
--SQL char->HEX code
DECLARE @str VARCHAR(4000)
SET @str='SELECT * from dbo.TaskHistory' --Your sql char
DECLARE @i INT,@Asi INT,@ModS INT,@res VARCHAR(800),@Len INT,@Cres VARCHAR(4),@te ......