ÔÚSql Server Öе÷ÓÃJmail×é¼þ·¢ËÍÓʼþ
ÔÚSql Server Öе÷ÓÃJmail×é¼þ·¢ËÍÓʼþ
Ô¤±¸ÖªÊ¶
1£®OLE×Ô¶¯»¯º¯Êý
OLE×Ô¶¯»¯Ê¹Ó¦ÓóÌÐòÄܹ»¶ÔÁíÒ»¸öÓ¦ÓóÌÐòÖÐʵÏֵĶÔÏó½øÐвÙ×÷£¬»òÕß½«¶ÔÏ󹫿ªÒÔ±ã¿ÉÒÔ¶ÔÆä½øÐвÙ×÷¡£×Ô¶¯»¯¿Í»§¶ËÊǿɶÔÊôÓÚÁíÒ»¸öÓ¦ÓóÌÐòµÄ¹«¿ª¶ÔÏó½øÐвÙ×÷µÄÓ¦ÓóÌÐò£¬±¾ÎÄÖµµÃÊÇSql Server¡£¹«¿ª¶ÔÏóµÄÓ¦ÓóÌÐò³ÆΪ×Ô¶¯»¯·þÎñÆ÷£¬ÓÖ³ÉΪ×Ô¶¯»¯×é¼þ£¬±¾ÎÄÖм´Jmail×é¼þ¿©¡£¿Í»§¶Ëͨ¹ý·ÃÎÊÓ¦ÓóÌÐò¶ÔÏóµÄÊôÐԺͺ¯Êý¶ÔÕâЩ¶ÔÏó½øÐвÙ×÷¡£
ÔÚSql ServerʹÓÃOle×é¼þµÄ;¾¶ÊǼ¸¸öϵͳÀ©Õ¹´æ´¢¹ý³Ìsp_OACreate¡¢sp_OADestroy¡¢sp_OAGetErrorInfo¡¢sp_OAMethod¡¢sp_OASetPropertyºÍsp_OAGetProperty£¬Ôٴμòµ¥µØ½éÉÜÒ»ÏÂʹÓ÷½·¨£¬Ïêϸ×ÊÁϲο¼Sql ServerÁª»ú´ÔÊé¡£
OLE×Ô¶¯»¯¶ÔÏóµÄʹÓ÷½·¨£º
£¨1£©µ÷ÓÃsp_OACreate ´´½¨¶ÔÏó¡£
¸ñʽ£ºsp_OACreate clsid,objecttoken OUTPUT [ , context ]
²ÎÊý£ºclsid——ÊÇÒª´´½¨µÄOLE ¶ÔÏóµÄ³ÌÐò±êʶ·û(ProgID)¡£´Ë×Ö·û´®ÃèÊö¸ÃOLE ¶ÔÏóµÄÀ࣬ÆäÐÎʽ£¬Èç'OLEComponent.Object'£¬OLEComponent ÊÇOLE ×Ô¶¯»¯·þÎñÆ÷µÄ×é¼þÃû³Æ£¬Object ÊÇOLE ¶ÔÏóÃû£¬±¾ÎÄÖÐʹÓõēJMail.Message”;
Objecttoken——ÊÇ·µ»ØµÄ¶ÔÏó±êÖ¾£¬²¢ÇÒ±ØÐëÊÇÊý¾ÝÀàÐÍΪint µÄ¾Ö²¿±äÁ¿¡£ÓÃÓÚ±êʶËù´´½¨µÄOLE ¶ÔÏ󣬲¢½«ÔÚµ÷ÓÃÆäËüOLE ×Ô¶¯»¯´æ´¢¹ý³ÌʱʹÓᣱ¾ÎÄÖоÍÊÇͨ¹ýËüÀ´µ÷ÓÃJMail.Message×é¼þµÄÊôÐԺͷ½·¨µÄ¡£
Context——Ö¸¶¨Ð´´½¨µÄOLE ¶ÔÏóÒªÔÚÆäÖÐÔËÐеÄÖ´ÐÐÉÏÏÂÎÄ¡£±¾ÎIJ»Ê¹ÓøòÎÊý£¬¹Ê²»×¸Êö¡£ÒÔÏÂÓë´ËÒ»Ö£¬ËùÓз½·¨ÊôÐÔµÄÆäËûÓ÷¨Çë²ÎÔÄSql ServerÁª»úÎĵµ¡£
£¨2£©Ê¹ÓøöÔÏó¡£
£¨a£©µ÷ÓÃsp_OAGetProperty »ñÈ¡ÊôÐÔÖµ¡£
¸ñʽ£º_OAGetProperty objecttoken,propertyname [, propertyvalue OUTPUT]
²ÎÊý£º£¨Ç°Ãæ³öÏÖ¹ýµÄ²ÎÊý£¬ÒÔϾùÊ¡ÂÔ¡££©
Propertyname——¶ÔÏóµÄÊôÐÔÃû³Æ£»
Propertyvalue——·µ»ØµÄ¶ÔÏóµÄÊôÐÔÖµ£¬¸Ã²ÎÊý´øOUTPUTÊôÐÔ£¬Ö´ÐиòÙ×÷ºó£¬Äã¾Í¿ÉÒÔ´ÓpropertyvalueÖеõ½ÊôÐÔµÄÖµÁË¡£
£¨b£©µ÷ÓÃsp_OASetProperty ½«ÊôÐÔÉèΪÐÂÖµ¡£
¸ñʽ£ºsp_OASetProperty
Ïà¹ØÎĵµ£º
Ò»°ãʹÓÃSQL ServerµÄ¼¯³ÉÈÏ֤ʱ£¬¶¼ÐèÒªµÇ½½øÓò£¬ÏÂÃæ½éÉÜÒ»ÖÖ²»ÐèÒªµÇ½Óò¾Í¿ÉÒÔʹÓÃÓòÓû§µÇ½SQL ServerµÄ·½·¨¡£
SQL Server Management Studio 2005ºÍ2008µÄ¿ì½Ý·½Ê½ÈçÏÂͼ£º
SQL Server 2008 x64: "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"
SQL ......
ÔÚSQL SERVERÖУ¬ÓÐʱÐèÒªºÏ¶àÁÐÖµµ½ÐеÄÐèÇ󣬳£¼ûµÄ·½·¨ÓУº1.´´½¨×Ô¶¨Ò庯Êý£¬2.ʹÓÃÓα귨½øÐÐ×Ö·û´®ºÏ²¢¡£3.ʹÓÃÁÙʱ±íʵÏÖ×Ö·û´®ºÏ²¢¡£ Êý¾Ý£º DEPTNO EMPS
------ ----------
10 CLARK
10 KING
10 MILLER
20 SMITH
20 ADAMS
20 FORD
20 SCOTT
20 JONES
30 ALLEN
30 BLAKE
30 MARTIN
30 JAMES
30 ......
µÚÒ»ÖÖ·½·¨:
string str="server=.;uid=sa;pwd=111111;database=text_db";//Á¬½Ó×Ö·û´®
SqlConnection SCON = null;//Á¬½Ó¶ÔÏó
&n ......
SQL Server 2005 ¾µÏñ¹¹½¨ÊÖ²á
Ò»¡¢ ¾µÏñ¼ò½é
1¡¢ ¼ò½é
Êý¾Ý¿â¾µÏñÊǽ«Êý¾Ý¿âÊÂÎñ´¦Àí´ÓÒ»¸öSQL ServerÊý¾Ý¿âÒƶ¯µ½²»Í¬SQL Server»·¾³ÖеÄÁíÒ»¸öSQL ServerÊý¾Ý¿âÖС£¾µÏñ²»ÄÜÖ±½Ó·ÃÎÊ;ËüÖ»ÓÃÔÚ´íÎó»Ö¸´µÄÇé¿öϲſÉÒÔ±»·ÃÎÊ¡£
Òª½øÐÐÊý¾Ý¿â¾µÏñËùÐèµÄ×îСÐèÇó°üÀ¨ÁËÁ½¸ö²»Í¬µÄSQL ServerÔËÐл·¾³¡£Ö÷·þÎñÆ÷± ......
SQL Server 2005 ¾µÏñ¹¹½¨ÊÖ²á(2)
3¡¢ ½¨Á¢¾µÏñ
ÓÉÓÚÊÇʵÑ飬ûÓÐΪ·þÎñÆ÷ÅäÖÃË«Íø¿¨£¬IPµØÖ·ÓëͼÓе㲻һÑù£¬µ«ÊÇÔÀíÒ»Ñù¡£
--Ö÷»úÖ´ÐУº
1ALTER DATABASE shishan SET PARTNER = 'TCP://10.168.6.45:5022';
--Èç¹ûÖ÷ÌåÖ´Ðв»³É¹¦£¬³¢ÊÔÔÚ±¸»úÖÐÖ´ÐÐÈçÏÂÓï¾ä£º
1ALTER DATABASE ......