SQL Server 2005 ÎÞ·¨µÇ½
ÎÊÌâÃèÊö
ÓÐÁ½Ì¨·þÎñÆ÷ DB1£¨10.10.10.1£© DB2£¨10¡¢10¡¢10¡¢2£© ÕâÁ½Ì¨»úÆ÷×öµÄ Ⱥ¼¯ ÐéÄâIP £¨10¡¢10¡¢10¡¢11£©
¹úÇì·Å¼Ù»ØÀ´·¢ÏÖ ·þÎñÆ÷ ÎÞ·¨µÇ½£¬±¾»úµÇ½£¬Ô¶³ÌµÇ¼¶¼²»¿ÉÒÔ¡£²¢ÇÒ SQLSERVER ·þÎñ¾³£Í£µô¡£
ÏëÅäÖÃÍâΧӦÓóÌÐò£¬½á¹û µ¯³ö Ìáʾ ¡°ÄúÎÞ·¨Í¨¹ýÁ¬½Óµ½¼ÆËã»úÃû³ÆÀ´ÅäÖÃȺ¼¯·þÎñµÄÍâΧӦÓã¬ÇëÁ¬½Óµ½ÐéÄâ·þÎñÆ÷
À´ÅäÖÃȺ¼¯·þÎñ¡£¡±
ÏÈлл¸÷λ¸ßÊÖ½â´ðÁË£¬
End_rbody_60301808//-->
¸Ã»Ø¸´ÓÚ2009-10-11 09:02:55±»¹ÜÀíԱɾ³ý
¶ÔÎÒÓÐÓÃ[0]
¶ª¸ö°åש[0]
ÒýÓÃ
¾Ù±¨
¹ÜÀí
TOP
kimma
(ÐÇ¿Õ)
µÈ¡¡¼¶£º
#2Â¥ µÃ·Ö£º0»Ø¸´ÓÚ£º2009-10-10 09:31:57
Â¥ÉϵÄÅ£ÈË 2009-10-10 05:20:50 »ØÌû£¡£¡£¡£¡£¡
Å£
²»Ì«Çå³þ
ѧϰÁË£¬²»ÖªµÀ¡£Å£ÈËѽ
ÖØÆôһϷþÎñÊÔÊÔ¡£
ÖØÆô»úÆ÷¡¡
ÎÒºÃÏëÖ»ÊÇʲôÊǼ¯Èº£¿ºÃÉñÆæµÄ¶«Î÷
°¦£¬²éÁËÁ½ÌìҲû²é³öÀ´ÎÊÌ⣬û°ì·¨£¬ÖØÐÂװϵͳ ÖØÐÂ×öµÄ Ⱥ¼¯¡£
É¢·Ö°É£¬Ð»Ð»¸÷λ»ØÌûÁË
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e
ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......
ÏÖÔÚÓÐÁ½¸öÒì¹¹µÄsql serverÊý¾Ý¿â,ÎÒÏ뽫µÚÒ»¸ö±íÖеÄÊý¾Ýµ¼Èëµ½µÚ¶þ¸ö±íÖÐ,×Ô¼ºÖ¸¶¨µ¼ÈëÊý¾ÝµÄ×Ö¶Î,ÈçºÎµ¼ÈëÊý¾ÝÄØ,´ó¼ÒÌÖÂÛÒ»ÏÂ?
dts¹¤¾ß
µ¼Èëµ¼³ö¹¤¾ß.
DD
¹þ¹þ£¬¹À¼ÆÕâλÊǵØQIOU¶¼Êܲ»Á˵Ä
Ö±½ÓÐ ......
СµÜÊǸöÐÂÊÖ ÏÖÔÚÓиöÎÊÌâÒ»Ö±²»Äܽâ¾ö
ÀýÈç
procedure produce_proc
@p001 nvarchar(8000),
@p002 nvarchar(8000),
@p003 nvarchar(8000),
& ......
ÎÒÓÐÒ»¸öÔºÍÈÕ×é³ÉµÄÊý×Ö£¬ÓÐÁ½×éÔºÍÈÕ
ÏëÔÚÉí·ÝÖ¤ºÅÖÐÌôÑ¡³öÔڸøÃÁ½×éÔÂÈÕÖ®¼ä³öÉúµÄÈË£¬²»ÖªµÀÓ¦¸ÃÔõôд.
Éí·ÝÖ¤ºÅÓпÉÄÜÊÇ15λ»òÕß18λ
ÔÂÈÕ×éºÏµÄÐÎʽÈçÏÂ
10-17/04-20
ÔÂ-ÈÕ/ÔÂ- ......
ÓÐ×Ö¶Î
ÈÕÆÚ£¬id
ÈÕÆÚ²»Öظ´£¬id ÓÐÖØ¸´
ÐèҪɸѡ³ö ÿ¸öidÀïÃæÈÕÆÚ×îÔçµÄÊý¾Ý¡£
SQL code:
select * from ±í t where not exists(select 1 from ±í where t.ÈÕÆÚ>ÈÕÆÚ and id=t.id)
SQL ......