Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÎÄ˼´´ÐµÄ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ÀïдSQLÓï¾ä£¨°ÑSQLÓï¾äд½øXMLÀ

ÄãÖªµÀXMLÎļþ°É£¿£¨²»ÖªµÀµÄGOOGLEÈ¥£¡£©ÄÇÄãÌý˵¹ýÔÚXMLÀïÊéдSQLÓï¾äÂ𣿻»¾ä»°Ëµ£¬°ÑÄãµÄÏîÄ¿ÀïËùÓÐSQLÓï¾ä´æ´¢ÔÚXMLÎļþÀÄãÌý˵¹ýÂð£¿Äã×ö¹ýÂð£¿
ÎÒÍ·´ÎÌý˵ÊÇС°¬¸æËßÎҵģ¬ÎҸҿ϶¨ËûÊǸöÕâ·½ÃæµÄ¸ßÊÖ£¬ºÇºÇ£¨ÔÞÒ»¸ö£¬µ½´ËΪֹ£¡£©
ÄǸøÄãչʾһÏ£¬ÔÚXMLÀïÊéдSQLÓï¾ä°É
<commands>
  <comman ......

sqlǶÌײéѯ

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)
......

sql serverÁ¬½ÓÊý¾Ý¿â×Ö·û´®

1¡¢WINDOWSÉí·ÝµÇ½£º
     <connectionStrings>
     <add name="connectionString" connectionString="Data Source=(local);Initial Catalog=AngelicaDB;Integrated      Security=True" providerName="System .Data .SqlClient" /> ......

SQL 2005 ASP.NETÊý¾Ý¿âÁ¬½Ó×ܽá

 
VS2005+SQL2005 ASP.NET2.0Êý¾Ý¿âÁ¬½Ó×ܽá
    Í¨¹ýÉÏÆªÎÄÕ£¨http://www.cnblogs.com/user34j/archive/2007/01/23/628426.html£©µÄÉèÖÃÆäʵÒѾ­²î²»¶àÍê³ÉÁË£¬Ö»ÊÇ»¹ÓÐһЩϸ½ÚµÄµØ·½Ã»ÓÐ×öºÃ£¬¾­¹ýÒ»·¬Ñо¿ÏÖÔÚÖÕÓڸ㶨ÁË¡£¶ÔÓÚÏñÎÒÕâÑùµÄÐÂÊÖÀ´Ëµ£¬Õû¸öÊý¾Ý¿âÁ¬½ÓÕæÊDz»ÈÝÒס£ÏÖ×ܽáÈçÏ£ ......

SQL SERVER 2000 °²×°Ìáʾ"Ò»°ãÐÔÍøÂç´íÎó"

 ½ñÌì°²×°SQL SERVER 2000 ¸öÈ˰棬°²×°×îºóµ¯³ö´íÎó¶Ô»°¿ò£º
“°²×°³ÌÐòÅäÖ÷þÎñÆ÷ʧ°Ü¡£²Î¿¼·þÎñÆ÷´íÎóÈÕÖ¾ºÍC:\windows\sqlstp.log”£¬´Ó¶øÎÞ·¨°²×°¡£
µ½¾ßÌåµÄĿ¼²é¿´ÏÔʾ"Ò»°ãÐÔÍøÂç´íÎó"£¬ÔÚÍøÉÏËÑË÷ÎÊÌâÔ­Òò¼°½â¾ö·½°¸ÈçÏ£º
´ËÎÊÌâÊôÓÚsql serverµÄbug, GetComputerName ÓÃÓÚ»ñÈ¡±¾µØ¼ÆËã»úÃû¡£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ