Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ʱ¼äÎÊÌâ

sql table±íÓиöÎı¾ÀàÐ͵Äa×ֶΣ¬´æ´¢µÄÄÚÈÝÈ«²¿ÊÇÊý×Ö£¬ÀýÈç2009001£¬2008578ÕâÑùµÄ¸ñʽ£»b×Ö¶ÎÎı¾ÀàÐÍ£¬´æµÄÒ²ÊÇÊý×ÖÀýÈç 001£¬123
aspÀïÃæ strday=100£¬strb=001

ÎÒÏë¶Á³ö£¬´Óa×ֶεÄÊý×Ö°´´óµ½Ð¡µÄË ......

sql server 2008 sql serverÉí·ÝÑéÖ¤ÎÊÌâ

ÎÒϵͳʽwin7 £¬Êý¾Ý¿âsqlserver2008.Ò»Ö±ÓÃwindowsÑéÖ¤£¬µÇ½£¬²»ÄÜÓÃsqlÑéÖ¤£¬ÔÚsaÉÏÖØÐÂ×¢²áÒ»¸öÓû§µÄ»°£¬µÇ½ʱµÚÒ»±é±¨
Òѳɹ¦Óë·þÎñÆ÷½¨Á¢Á¬½Ó£¬µ«ÊÇÔڵǼ¹ý³ÌÖз¢Éú´íÈ¡¡££¨provider:¹²ÏíÄÚ´æÌṩ³ÌÐò£¬ ......

ÇóSQLÓï¾ä

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

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

sql²éѯÎÊÌâ

²»ÖªµÀÎÒÃèÊöÇå³þÁËÂð£¬ÎÒÏÖÔÚÊÇÏëÒªÓÃÒ»¸ösqlÓï¾äʵÏÖÕâÑùµÄ¹¦ÄÜ£¬ÇëÎÊ¿ÉÒÔÂð£¬ÓÐûÓиüºÃµÄ°ì·¨À´ÊµÏÖ£¿
лл´ó¼ÒÁË
ʲô¹¦ÄÜ£¿

ÔÎ,

..

ΪʲôÎÒÃèÊöµÄÎÊÌâ·¢±í²»ÁË£¬×Ü˵ÓзǷ¨´Ê»ò´Ê×飬ÎÒ²éÁËÏÂû ......

sql²éѯÎÊÌâ

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