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

SQL MAIL µÄÅäÖÃ

ÎÊÌâÃèÊö£º
ÎÒÓõÄÊÇsql 2000
ÆóÒµ¹ÜÀíÆ÷->Õ¹¿ª·þÎñÆ÷->¹ÜÀí->SQL Agent->ÊôÐÔ
ÔÚ´¦À´µÄSQL Server´úÀíÊôÐÔ¶Ô»°¿òÖÐ Óʼþ»á»°Ñ¡Ïî¿òÏÂÃæµÄ ÓʼþÅäÖÃÎļþ ²»ÄÜÓà ³ÊÏÖ»ÒÉ«
ÎÒͬѧµÄÈ´ÄÜÓá£ÎÊÁ˺ܶàÈË ¶¼Ã»Óнâ¾ö
Ö»ºÃÀ´csdnÀ´Âé·³´ó¼ÒÁË Ð»Ð»

ѧϰ£¬°ï¶¥

лл

ÎÒµÄÒ²²»ÄÜÓÃ

ÄÇÊÇʲôԭÒòÄØ ÓеÄÈ´ÄÜÓÃ

°²×° outlook£¬ÔÚ outlook ÖÐÅäÖÃÓʼþÕ˺š£

ÒýÓÃ
°²×° outlook£¬ÔÚ outlook ÖÐÅäÖÃÓʼþÕ˺š£

ÎÒÒѾ­ÅäÖúÃÁËoutlook°¡ ÎÒÐèÒªÓÃsql´úÀí·¢ËÍÓʼþ
µ«ÊÇÄǸöÓʼþ»á»°Óò»ÁË

SQL Server ·þÎñºÍ SQL Server Agent ·þÎñµÄ·þÎñÕË»§ÊDZ¾µØ administrator ÕË»§»òÓòÕË»§Âð£¿

outlook ÖеÄÓʼþÕË»§ÊÇ·ñÔÚÒÔ¡°SQL Server Agent ·þÎñµÄ·þÎñÕË»§¡±×÷Ϊ windows ½»»¥µÇ½ÕË»§µÄ»·¾³ÏÂÅäÖã¿



Ïà¹ØÎÊ´ð£º

Á½¸öµ¼¹¹sql serverÊý¾Ý¿â,Êý¾Ýµ¼Èëµ¼³öÎÊÌâ

ÏÖÔÚÓÐÁ½¸öÒì¹¹µÄsql serverÊý¾Ý¿â,ÎÒÏ뽫µÚÒ»¸ö±íÖеÄÊý¾Ýµ¼Èëµ½µÚ¶þ¸ö±íÖÐ,×Ô¼ºÖ¸¶¨µ¼ÈëÊý¾ÝµÄ×Ö¶Î,ÈçºÎµ¼ÈëÊý¾ÝÄØ,´ó¼ÒÌÖÂÛÒ»ÏÂ?
dts¹¤¾ß

µ¼Èëµ¼³ö¹¤¾ß.

DD

¹þ¹þ£¬¹À¼ÆÕâλÊǵØQIOU¶¼Êܲ»Á˵Ä

Ö±½ÓÐ ......

ÇóSQLÓï¾ä

ÏÖÔÚÓÐÁ½Õűí
a±íºÍb±í

a±í:
¹¤ºÅ  ÐÕÃû  ËùÊô²¿ÃűàºÅ
001              A
002              B
003&n ......

ÇóSQLÓï¾äµÄд·¨

ÎÒÏÖÔÚÓÐ2¸ö±íTable1£¬Table2¡£¶ÔÓ¦µÄ×ֶΡ¢Êý¾ÝÈçÏ£º

Table1£ºprimary key(a1)
a1(char)      a2(int)
  a            10
  b  & ......

¹ØÓÚSQL 2008

Ò»Ö±ÓÃ2000£¬Ïëѧ2008.
ÇëÎÊ
1. 2008±È2000ÓÐÄÄЩ¸ü·½±ãµÄÓ¦Óã¿
2. MSSQL 2008 Ö§³ÖÄÄЩϵͳ£¿ XP¿ÉÒÔ°²×°Âð£¿
3. ÔÚÄÄÓÐÏÂÔØ£¬×îºÃÊÇÃâϵÁкţ¬¼´D°æ¡£

лл£¡
ÎÒÒ²ÓÃ2000

1.Ì«¶àÁË ×Ô¼ºÈ¥ ......

sql²éѯÎÊÌâ

http://wenda.tianya.cn/wenda/thread?tid=008e40988f9b74c0
ÎÒµÄÎÊÌâдÔÚÕâÀïÁ˰ÝÍдó¼Ò¿´¿´£¬ÉÏÎçcsndÉý¼¶²»ÄÜÓþÍÔÚÌìÑÄÉÏдÁË¡£
ÕâÀïÃæÐ´ÁË·¢±í²»ÁË×Ü˵ÓзǷ¨´Ê»ò´Ê×éºÜÓôÃÆ£¬Ð»Ð»´ó¼Ò 
FULL JOI ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ