SQLSERVERÍâÁ¬½Ó·û
±íA
tmpA:
id name
00 Ãû×ÖA
01 Ãû×ÖB
02 Ãû×ÖC
03 Ãû×ÖD
04 Ãû×ÖE
tmpB:
id class
02 °à¼¶A
06 °à¼¶B
ÔÚMicrosft SQL SERVER Management Studio ÖÐÖ´ÐÐÕâ¸öÓï¾ä select tmpA.id, tmpB.class from tmpA,tmpB where tmpB.id=*tmpA.id;¾Í»á±¨Õâ¸ö´í¡¾ÏûÏ¢ 4147£¬¼¶±ð 15£¬×´Ì¬ 1£¬µÚ 2 ÐÐ
´Ë²éѯʹÓõIJ»ÊÇ ANSI ÍⲿÁª½ÓÔËËã·û("*=" »ò "=*")¡£ÈôÒª²»½øÐÐÐ޸ļ´ÔËÐд˲éѯ£¬ÇëʹÓô洢¹ý³Ì sp_dbcmptlevel ½«µ±Ç°Êý¾Ý¿âµÄ¼æÈݼ¶±ðÉèÖÃΪ 80 »ò¸üµÍ¡£¼«Á¦½¨ÒéʹÓà ANSI ÍⲿÁª½ÓÔËËã·û(LEFT OUTER JOIN¡¢RIGHT OUTER JOIN)ÖØд´Ë²éѯ¡£ÔÚ½«À´µÄ SQL Server °æ±¾ÖУ¬¼´Ê¹ÔÚÏòºó¼æÈÝģʽÏ£¬Ò²²»Ö§³Ö·Ç ANSI Áª½ÓÔËËã·û¡£¡¿
¶ø´ÓjavaÀïµ÷ÓÃÖ´ÐУ¬¾Í¿ÉÒÔÕý³£Ö´ÐС£ '²»Ã÷°×Ϊʲô£¿'
<SQLSERVERÍâÁ¬½Ó·ûΪ'*',¶øORACLEΪ'+'>
select tmpA.id, tmpB.class from tmpA,tmpB where tmpB.id=*tmpA.id;
Óï¾äµÈ¼ÛÓÚ select tmpA.id, tmpB.class from tmpA LEFT JOIN tmpB on tmpB.id=tmpA.id
Êä³ö½á¹û£º
id class
00 NULL
01 NULL
02 °à¼¶A
03 NULL
04 NULL
//////////////
select tmpA.id, tmpB.class from tmpA RIGHT JOIN tmpB on tmpB.id=tmpA.id
Êä³ö½á¹û£º
id class
02 °à¼¶A
NULL °à¼¶B
//////////////
select tmpA.id, tmpB.class from tmpA FULL JOIN tmpB on tmpB.id=tmpA.id
Êä³ö½á¹û£º
id class
00 NULL
01 NULL
02 °à¼¶A
03 NULL
04 NULL
NULL °à¼¶B
Ïà¹ØÎĵµ£º
ÔÚÖ÷Êý¾Ý¿âÎļþ½øÐдóÁ¿µÄɾ³ý(ÐÂÔö£¬Ð޸Ķ¼»áÓÐÈÕÖ¾)£¬ÈÕÖ¾ÎļþÓÐ1.5G¡£×òÌ컹ÔÊý¾Ý¿âʱ³õʼֵҲ²Å1MB¡£±ØÐëÇå³ýµô£¬²»È»Ì«Õ¼¿Õ¼äÁË¡£ÉÏÍøÕÒÁ˸öÇå³ýÈÕÖ¾µÄ·½·¨¡£Ë³Àû½«ÈÕÖ¾Îļþlog.ldf´Ó1.5G±äΪÁË1M¡£ ÎÒÖ´ÐÐÈçÏ£º
1.Çå¿ÕÈÕÖ¾
DUMP TRANSACTION ¿âÃû WITH NO_LOG
2.½Ø¶ÏÊÂÎñÈÕÖ¾£º
BACKUP LOG ......
ÕûÀíһϣ¬¹ØÓÚÓα꣬MSDNÓУº
¹ý Transact-SQL ·þÎñÆ÷Óαê¼ìË÷Ìض¨ÐС£
Transact-SQL Óï·¨Ô¼¶¨
²ÎÊý
NEXT
½ô¸úµ±Ç°Ðзµ»Ø½á¹ûÐУ¬²¢ÇÒµ±Ç°ÐеÝÔöΪ·µ»ØÐС£Èç¹û FETCH NEXT Ϊ¶ÔÓαêµÄµÚÒ»´ÎÌáÈ¡²Ù×÷£¬Ôò·µ»Ø½á¹û¼¯ÖеĵÚÒ»ÐС£NEXT ΪĬÈϵÄÓαêÌáÈ¡Ñ¡Ïî¡£
PRIOR
·µ»Ø½ôÁÚµ±Ç°ÐÐÇ°ÃæµÄ½á¹ûÐУ¬²¢ÇÒµ±Ç° ......
¹«Ë¾×éÖ¯SQLˮƽ¿¼ÊÔ£¬¿´ÁËд½Ì²Ä£¬Ð´Á˵ã×ܽᷢÉÏÀ´¸ú´ó¼Ò·ÖÏí¡£
ÎÒ¹«Ë¾Ê¹ÓõÄÊÇSybase ASE12.5£¬ËùÒÔÏÂÃæµÄһЩÌØÐÔÊÇÕë¶ÔSybase ASEµÄ¡£
Ò»£ºSQL Bisic
1£ºSQL(Structured Quary Language)ÌØÐÔ£º
a£º±ê×¼»¯
b£º·Ç¹ý³Ì»¯µÄ
c£º¿ÉÓÅ»¯µÄ
d£ºÃæÏò¼¯ºÏ²Ù×÷µÄ
2£ºASEÖеÄÊý¾ÝÀàÐÍ
a£ºNumberic
b£ºCharacter
c£ºDa ......
ÏÖÏó£º
ÔÚ×°SqlServer 2000ʱ£¬ÀÏÊǵ¯³ö“ÁíÒ»¸öʵÀýÕýÔÚÔËÐДµÄ´íÎóÐÅÏ¢£¬½áÊøÁ˽ø³ÌÀïsqlµÄÏà¹ØÎļþºÍɾ³ýÒÔÇ°°²×°¹ýµÄ°²×°Ä¿Â¼ÏµÄsqlÎļþºó£¬ÖØÆôµçÄÔºó°²×°»¹ÊdzöÏÖÕâÖÖÇé¿ö¡£
´¦Àí°ì·¨£º
ÕâÖÖÇé¿öÒ»°ãÊÇSqlServer 2000жÔز»ÍêÈ«Ôì³ÉµÄ¡£
ÔÚ“¿ªÊ¼-ÔËÐДÖÐÊäÈëregeditµ÷³ö×¢²á±í£¬ÕÒµ½£ ......