ÎÄ˼´´ÐµÄSQL±ÊÊÔÌâ
ÌâÄ¿£ºÓÐAºÍBÁ©¸ö±í£¬¶¼¶¨ÒåÏàͬµÄÖ÷¼ü£¬Ð´³öSQLÓï¾äÕÒ³öA±íÖÐÓжøB±íÖÐûÓеļǼ£¬È»ºó°ÑûÓеļǼ²åÈëµ½B±íÖС£
SQLÓï¾äÈçÏ£º
CREATE TABLE A_MINUS_B AS ---´´½¨Ò»¸ö²î¼¯±íA_MINUS_B ,×¢ÒâSELECT Óï¾äÒ»¶¨ÒªA±íÔÚǰ¡£
SELECT * from A
MINUS
SELECT * from B
INSERT INTO B(field1,field2,........) ----°Ñ²î¼¯²åÈëB±í£¬×¢Òâ²åÈëµÄ×Ö¶Î˳ÐòÒªÏàͬ£¬Êý¾ÝÀàÐÍÒ²ÒªÏàͬ¡£
SELECT field1,field2......
from A_MINUS_B
ÉÏÃæÓï¾äÔÚORACLE 10G ÒÔDEPT±íΪÊÔÑéÖ´Ðгɹ¦¡£Ò²¿ÉÄÜÓиü¸ßЧµÄ°ì·¨£¬´ó¼ÒÒ»ÆðÀ´ÌÖÂÛ¡£¿ÉÓÃÓαêÀ´´¦Àí°É£¬ÎÒ»¹Ã»Ñ§µ½Õⲿ·Ö¡£ÒÔºóÓÐÎһᲹÉÏ£¬µ±È»¸÷λ´óÏÀÒ²¿ÉÏÈдÉÏÁË¡£
insert into B select * from A where not exists(select 1 from B where B.KEYWORD = A.KEYWORD)
Ïà¹ØÎĵµ£º
ÄãÖªµÀXMLÎļþ°É£¿£¨²»ÖªµÀµÄGOOGLEÈ¥£¡£©ÄÇÄãÌý˵¹ýÔÚXMLÀïÊéдSQLÓï¾äÂ𣿻»¾ä»°Ëµ£¬°ÑÄãµÄÏîÄ¿ÀïËùÓÐSQLÓï¾ä´æ´¢ÔÚXMLÎļþÀÄãÌý˵¹ýÂð£¿Äã×ö¹ýÂð£¿
ÎÒÍ·´ÎÌý˵ÊÇС°¬¸æËßÎҵģ¬ÎҸҿ϶¨ËûÊǸöÕâ·½ÃæµÄ¸ßÊÖ£¬ºÇºÇ£¨ÔÞÒ»¸ö£¬µ½´ËΪֹ£¡£©
ÄǸøÄãչʾһÏ£¬ÔÚXMLÀïÊéдSQLÓï¾ä°É
<commands>
<comman ......
select * from sq_donglong.achi_news where ID in (select ID from (select top 6 ID from sq_donglong.achi_news where SortID=82)a union all select ID from (select top 6 ID from sq_donglong.achi_news where SortID=84)b)
......
½ñÌì´ÓÍøÂçÉÏÕÒµ½ÁËÔÚXPÉϰ²×°SQL 2000 ServerµÄ·½·¨£¬´ËǰÎÒÒ»Ö±ÈÏΪÕâÊÇÐв»Í¨µÄ£¬ºóÃægoogleÒ»²é£¬»¹ÕæÊÇ¿ÉÒÔ£¬ÓкܶàÍøÕ¾¶¼ËµÕâ¸ö·½·¨¿ÉÐУ¬ÎÒ¾ÍÈÃlpÊÔÊÔ¿´£¬½á¹ûÕæÐУ¬×ªÔØÒ»Ï°ɣº ÔÚWindows XPÉϰ²×°SQL Server 2000µÄÖ÷ÒªÁ÷³ÌΪ£º
Ò»¡¢ÔÚSQL·þÎñÆ÷µÄ°²×°ÅÌÖÐÕÒµ½MSDEÕâ¸öĿ¼£¬²¢ÇÒµã»÷setup.exe°²×°Ëü£¬¹ý³Ì ......
Èç¹ûÄãÕýÔÚ¸ºÔðÒ»¸ö»ùÓÚSQL ServerµÄÏîÄ¿£¬»òÕßÄã¸Õ¸Õ½Ó´¥SQL Server£¬Äã¶¼ÓпÉÄÜÒªÃæÁÙһЩÊý¾Ý¿âÐÔÄܵÄÎÊÌ⣬ÕâÆªÎÄÕ»áΪÄãÌṩһЩÓÐÓõÄÖ¸µ¼£¨ÆäÖдó¶àÊýÒ²¿ÉÒÔÓÃÓÚÆäËüµÄDBMS£©¡£
ÔÚÕâÀÎÒ²»´òËã½éÉÜʹÓÃSQL ServerµÄÇÏÃÅ£¬Ò²²»ÄÜÌṩһ¸ö°üÖΰٲ¡µÄ·½°¸£¬ÎÒËù×öµÄÊÇ×ܽáһЩ¾Ñé----¹ØÓÚÈçºÎÐγÉÒ»¸öºÃµÄÉè¼Æ¡£Õ ......
SQLÓï¾ä¸´ÖƱíµÄ·½·¨
(2009-08-29 13:41:54)
±êÇ©£º
sql
·ÖÀࣺ¼ÆËã»ú֪ʶ
Èç¹ûÄ¿µÄ±íÒѾ´æÔÚ:
insert into DATAHR.DBO.GBITEM
select * from DEMO.DBO.GBITEM
Èç¹ûÄ¿µÄ±í²»´æÔÚ:
select * into DATAHR.DBO.GBITEM
from DEMO.DBO.GBITEM
¿ç¿âµ¼Èë
select * into [zk_news].[dbo].[News1] from [zk_media].[ ......