sql Server2000 Êý¾Ý¿âÓʼþ
*
ÌṩÁ½ÖÖ°æ±¾µÄOutLookÓʼþ·¢ËÍ·½Ê½
ÓÐÒÉÎÊÁªÏµ×÷Õß: zlp321001@hotmail.com
*/
A:ÀûÓÃOutLook2003·¢ËÍÓʼþ
----------------------------------------------------------------------
/
*²âÊÔ»·¾³: windowx Xp
OutLook: OutLook 2003
²âÊԵĵç×ÓÓʼþ: zlp321001@126.com
/
µÚÒ»²½Ö裺½¨ÅäÖÃÎļþ
¿ªÊ¼->¿ØÖÆÃæ°æ->Óʼþ>Ë«»÷Óʼþ->Ìí¼Ó->ÅäÖÃÎļþÃû³Æ(SQLSendMailServer)
Ìí¼Óеç×ÓÓʼþÕÊ»§->Ñ¡ÔñPOP3(P)->
Óû§ÐÅÏ¢:
ÐÕÃû:zlp
ÓʼþµØÖ·:zlp321001@126.com
µÇ¼ÐÅÏ¢:
Óû§Ãû:zlp321001
ÃÜÂë:****
·þÎñÆ÷ÐÅÏ¢:(×¢Òâ:ÿһ¸ö·þÎñÆ÷ÐÅÏ¢ÅäÖþù²»Ò»Ñù,²Î¿¼´Ë·þÎñÆ÷ÅäÖðïÖú,±ÈÈçÐÂÀ˾Ͳ»Ò»Ñù)
½ÓÊÕÓʼþ·þÎñÆ÷(POP3)(I): pop3.126.com
·¢ËÍÓʼþ·þÎñÆ÷(SMTP)(O): smtp.126.com
µã»÷ÆäËûÉèÖÃ->·¢ËÍ·þÎñÆ÷->Ñ¡ÖÐ(Îҵķ¢ËÍ·þÎñÆ÷(SMTP)ÒªÇóÑéÖ¤)->Ñ¡ÔñµÇ¼ʹÓÃ
Óû§Ãû:zlp321001
ÃÜÂë:****
Ñ¡ÖмÇסÃÜÂë
È·¶¨
²âÊÔÕÊ»§ÉèÖÃ->³É¹¦->ÏÂÒ»²¿->È·¶¨
´ò¿ªOutLookÈí¼þ£¬²âÊÔÊÇ·ñÄÜÕý³£½ÓÊÕÓʼþ£¬Ò»ÇÐOK,½øÐÐÏÂÒ»²½ÅäÖÃ
µÚ¶þ²½Ö裺ÅäÖÃÊý¾Ý¿â·þÎñÆ÷²ÉÓÃÓʼþÅäÖÃÎļþ
ÖØÐÂÆô¶¯MSSQLSERVER ·þÎñ(ÅäÖóÉÓòÓû§)
¿ªÊ¼->¿ØÖÆÃæ°æ->¹ÜÀí¹¤¾ß->·þÎñ->Ñ¡ÔñMSSQLSERVER·þÎñ->ÊôÐÔ->µÇ¼->
Á÷ÀÀ(ÎÒ»úÆ÷ÊÇÓû§Ãû:zlp,ÃÜÂëZlpµÇ¼)Ñ¡ÖиÃÓû§ÃûºÍÊäÈëÃÜÂë
SQLSERVERAGENT ¸ü¸ÄÈçÉÏÃæ
ÖØÐÂÆô¶¯ÕâÁ½¸ö·þÎñ(OutLookÅäÖúú󣬱ØÐëÖØÆô£¬SQLÓʼþ·þÎñ²Å»áÓÐЧ)
µÚÈý²½Öè:Êý¾Ý¿âÑéÖ¤ÊÇ·ñ³É¹¦
ÆóÒµ¹ÜÀíÆ÷->Õ¹¿ª·þÎñÆ÷->Õ¹¿ªÖ§³Ö·þÎñ->SQLÓʼþ->ÊôÐÔ->·¢ÏÖ"SQLSendMailServer"ÓÐÕâ¸öÅäÖÃÎļþÃû³Æ
²âÊÔͨ¹ý
µÚËIJ½Öè:д¼òµ¥µÄ·¢ËÍÓʼþ³ÌÐò,²âÊÔ
exec master..xp_sendmail 'zlp@zehua.com.cn', '²âÊÔÀ´×ÔÊý¾Ý¿â·¢Ë͵ÄÓʼþ'
exec master..xp_sendmail 'zlp321001@zehua.com.cn', '²âÊÔÀ´×ÔÊý¾Ý¿â·¢Ë͵ÄÓʼþ'
exec master..xp_sendmail 'qvb0803@sina.com.cn', '²âÊÔÀ´×ÔÊý¾Ý¿â·¢Ë͵ÄÓʼþ'
exec master..xp_sendmail 'zlp321001@hotmail.com', '²âÊÔÀ´×ÔÊý¾Ý¿â·¢Ë͵ÄÓʼþ'
²âÊÔ¾ù³É¹¦,¿ÉÄÜÓзþÎñÆ÷ÑÓʱÎÊÌâ,×÷Õß´Ó¾ùzlp321001@126.comÊÕµ½Á˸ÃÓʼþ
----------------------------------------------------------------------------------------------------------
B:ÀûÓÃOutLook2000·¢ËÍÓʼþ
/
*²âÊÔ»·¾³: windowx Xp
OutLook: OutLook 2000
Ïà¹ØÎĵµ£º
sql serverµÄËæ»úº¯ÊýnewID()ºÍRAND()¡¡¡¡
¡¡¡¡SELECT * from Northwind..Orders ORDER BY NEWID()
¡¡¡¡--Ëæ»úÅÅÐò
¡¡¡¡SELECT TOP 10 * from Northwind..Orders ORDER BY NEWID()
¡¡¡¡--´ÓOrders±íÖÐËæ»úÈ¡³ö10Ìõ¼Ç¼¡¡¡¡
¡¡¡¡Ê¾Àý¡¡¡¡
¡¡¡¡A.¶Ô±äÁ¿Ê¹Óà NEWID º¯Êý
¡¡¡¡ÒÔÏÂʾÀýʹÓà NEWID() ¶ÔÉùÃ÷Ϊ uniq ......
Èë Êƪ
Èç¹ûÄãÒÔǰûÊÔ¹ýSQL×¢ÈëµÄ»°£¬ÄÇôµÚÒ»²½ÏȰÑIE²Ëµ¥=>¹¤¾ß=>InternetÑ¡Ïî=>¸ß¼¶=>ÏÔʾÓѺà HTTP ´íÎóÐÅÏ¢Ç°ÃæµÄ¹´È¥µô¡£·ñÔò£¬²»ÂÛ·þÎñÆ÷·µ»ØÊ²Ã´´íÎó£¬IE¶¼Ö»ÏÔʾΪHTTP 500·þÎñÆ÷´íÎ󣬲»ÄÜ»ñµÃ¸ü¶àµÄÌáʾÐÅÏ¢¡£
µÚÒ»½Ú¡¢SQL×¢ÈëÔÀí
ÒÔÏÂÎÒÃÇ´ÓÒ»¸öÍøÕ¾www.19cn.com¿ªÊ¼£¨×¢£º±¾ÎÄ·¢±íǰÒÑÕ÷µ ......
À´Ô´:http://hi.baidu.com/czgblog/blog/item/3abd5aa911d51ff51f17a292.html
function OnFirstUIAfter()
STRING szTitle, szMsg1, szMsg2, szOpt1, szOpt2;
NUMBER bvOpt1, bvOpt2;
NUMBER bShowUpdateServiceDlg;
......
¼ÇÈ¡¼Ç¼¼¯
create procedure getArticle
as
select * from Article_Content
GO
asp.net µ÷Ó÷½·¨
SqlConnection Conn = new SqlConnection();
Conn.ConnectionString = Data.Connstr();
Conn.Open();
......