SQL MAIL µÄÅäÖÃ
ÎÊÌâÃèÊö£º
ÎÒÓõÄÊÇsql 2000
ÆóÒµ¹ÜÀíÆ÷->Õ¹¿ª·þÎñÆ÷->¹ÜÀí->SQL Agent->ÊôÐÔ
ÔÚ´¦À´µÄSQL Server´úÀíÊôÐÔ¶Ô»°¿òÖÐ Óʼþ»á»°Ñ¡Ïî¿òÏÂÃæµÄ ÓʼþÅäÖÃÎļþ ²»ÄÜÓà ³ÊÏÖ»ÒÉ«
ÎÒͬѧµÄÈ´ÄÜÓá£ÎÊÁ˺ܶàÈË ¶¼Ã»Óнâ¾ö
Ö»ºÃÀ´csdnÀ´Âé·³´ó¼ÒÁË Ð»Ð»
ѧϰ£¬°ï¶¥
лл
ÎÒµÄÒ²²»ÄÜÓÃ
ÄÇÊÇʲôÔÒòÄØ ÓеÄÈ´ÄÜÓÃ
°²×° outlook£¬ÔÚ outlook ÖÐÅäÖÃÓʼþÕ˺š£
ÎÒÒѾÅäÖúÃÁËoutlook°¡ ÎÒÐèÒªÓÃsql´úÀí·¢ËÍÓʼþ
µ«ÊÇÄǸöÓʼþ»á»°Óò»ÁË
SQL Server ·þÎñºÍ SQL Server Agent ·þÎñµÄ·þÎñÕË»§ÊDZ¾µØ administrator ÕË»§»òÓòÕË»§Âð£¿
outlook ÖеÄÓʼþÕË»§ÊÇ·ñÔÚÒÔ¡°SQL Server Agent ·þÎñµÄ·þÎñÕË»§¡±×÷Ϊ windows ½»»¥µÇ½ÕË»§µÄ»·¾³ÏÂÅäÖã¿
Ïà¹ØÎÊ´ð£º
sql table±íÓиöÎı¾ÀàÐ͵Äa×ֶΣ¬´æ´¢µÄÄÚÈÝÈ«²¿ÊÇÊý×Ö£¬ÀýÈç2009001£¬2008578ÕâÑùµÄ¸ñʽ£»b×Ö¶ÎÎı¾ÀàÐÍ£¬´æµÄÒ²ÊÇÊý×ÖÀýÈç 001£¬123
aspÀïÃæ strday=100£¬strb=001
ÎÒÏë¶Á³ö£¬´Óa×ֶεÄÊý×Ö°´´óµ½Ð¡µÄË ......
ÎÒϵͳʽwin7 £¬Êý¾Ý¿âsqlserver2008.Ò»Ö±ÓÃwindowsÑéÖ¤£¬µÇ½£¬²»ÄÜÓÃsqlÑéÖ¤£¬ÔÚsaÉÏÖØÐÂ×¢²áÒ»¸öÓû§µÄ»°£¬µÇ½ʱµÚÒ»±é±¨
Òѳɹ¦Óë·þÎñÆ÷½¨Á¢Á¬½Ó£¬µ«ÊÇÔڵǼ¹ý³ÌÖз¢Éú´íÈ¡¡££¨provider:¹²ÏíÄÚ´æÌṩ³ÌÐò£¬ ......
ÏÖÔÚÓÐÁ½Õűí
a±íºÍb±í
a±í:
¹¤ºÅ ÐÕÃû ËùÊô²¿ÃűàºÅ
001 A
002 B
003&n ......
²»ÖªµÀÎÒÃèÊöÇå³þÁËÂð£¬ÎÒÏÖÔÚÊÇÏëÒªÓÃÒ»¸ösqlÓï¾äʵÏÖÕâÑùµÄ¹¦ÄÜ£¬ÇëÎÊ¿ÉÒÔÂð£¬ÓÐûÓиüºÃµÄ°ì·¨À´ÊµÏÖ£¿
лл´ó¼ÒÁË
ʲô¹¦ÄÜ£¿
ÔÎ,
..
ΪʲôÎÒÃèÊöµÄÎÊÌâ·¢±í²»ÁË£¬×Ü˵ÓзǷ¨´Ê»ò´Ê×飬ÎÒ²éÁËÏÂû ......
http://wenda.tianya.cn/wenda/thread?tid=008e40988f9b74c0
ÎÒµÄÎÊÌâдÔÚÕâÀïÁ˰ÝÍдó¼Ò¿´¿´£¬ÉÏÎçcsndÉý¼¶²»ÄÜÓþÍÔÚÌìÑÄÉÏдÁË¡£
ÕâÀïÃæÐ´ÁË·¢±í²»ÁË×Ü˵ÓзǷ¨´Ê»ò´Ê×éºÜÓôÃÆ£¬Ð»Ð»´ó¼Ò
FULL JOI ......