﻿<?xml version="1.0" encoding="utf-8" standalone="yes"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/"><channel><title>博客园-Benny Ng 的猫博客-最新评论</title><link>http://www.cnblogs.com/miaomiaoga/CommentsRSS.aspx</link><description>吃饱了饭了没事干~没事干~</description><language>zh-cn</language><pubDate>Wed, 26 Oct 2011 08:28:54 GMT</pubDate><lastBuildDate>Wed, 26 Oct 2011 08:28:54 GMT</lastBuildDate><generator>cnblogs</generator><item><title>Re:Comparing escape(), encodeURI(), and encodeURIComponent()</title><link>http://www.cnblogs.com/miaomiaoga/archive/2010/12/31/1923282.html#2001447</link><dc:creator>Benny Ng</dc:creator><author>Benny Ng</author><pubDate>Fri, 31 Dec 2010 09:07:11 GMT</pubDate><guid>http://www.cnblogs.com/miaomiaoga/archive/2010/12/31/1923282.html#2001447</guid><description><![CDATA[前台用unscape，后台就用server.decode去解。<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/miaomiaoga/" target="_blank">Benny Ng</a> 2010-12-31 17:07 <a href="http://www.cnblogs.com/miaomiaoga/archive/2010/12/31/1923282.html#2001447#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:Description of the Windows Installer CleanUp Utility</title><link>http://www.cnblogs.com/miaomiaoga/archive/2010/08/17/611015.html#1895193</link><dc:creator>刘宁Toby</dc:creator><author>刘宁Toby</author><pubDate>Tue, 17 Aug 2010 01:43:40 GMT</pubDate><guid>http://www.cnblogs.com/miaomiaoga/archive/2010/08/17/611015.html#1895193</guid><description><![CDATA[这个链接已经过期了。<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/miaomiaoga/" target="_blank">刘宁Toby</a> 2010-08-17 09:43 <a href="http://www.cnblogs.com/miaomiaoga/archive/2010/08/17/611015.html#1895193#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:今天突然出现了Property IsLocked is not available for Login '[sa]'，我太阳，下面有绝招对付它！</title><link>http://www.cnblogs.com/miaomiaoga/archive/2009/12/26/1444762.html#1734019</link><dc:creator>季末＆寂寞</dc:creator><author>季末＆寂寞</author><pubDate>Sat, 26 Dec 2009 01:58:40 GMT</pubDate><guid>http://www.cnblogs.com/miaomiaoga/archive/2009/12/26/1444762.html#1734019</guid><description><![CDATA[.........................................................
<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/miaomiaoga/" target="_blank">季末＆寂寞</a> 2009-12-26 09:58 <a href="http://www.cnblogs.com/miaomiaoga/archive/2009/12/26/1444762.html#1734019#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:今天在debian下安装了thunderbird [转]</title><link>http://www.cnblogs.com/miaomiaoga/archive/2009/12/06/1592179.html#1715590</link><dc:creator>unistd</dc:creator><author>unistd</author><pubDate>Sat, 05 Dec 2009 17:38:06 GMT</pubDate><guid>http://www.cnblogs.com/miaomiaoga/archive/2009/12/06/1592179.html#1715590</guid><description><![CDATA[3.0.6 (去除 品牌版本的 Mozilla Firefox)、Icedove 2.0.0.19 (去除品牌版本的 Mozilla Thunderbird)、<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/miaomiaoga/" target="_blank">unistd</a> 2009-12-06 01:38 <a href="http://www.cnblogs.com/miaomiaoga/archive/2009/12/06/1592179.html#1715590#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:CruiseControl.NET持续集成实践</title><link>http://www.cnblogs.com/miaomiaoga/archive/2009/11/12/1507571.html#1696301</link><dc:creator>Benny Ng</dc:creator><author>Benny Ng</author><pubDate>Thu, 12 Nov 2009 03:50:11 GMT</pubDate><guid>http://www.cnblogs.com/miaomiaoga/archive/2009/11/12/1507571.html#1696301</guid><description><![CDATA[转贴的。不客气。<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/miaomiaoga/" target="_blank">Benny Ng</a> 2009-11-12 11:50 <a href="http://www.cnblogs.com/miaomiaoga/archive/2009/11/12/1507571.html#1696301#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:CentOS 挂载可写NTFS分区 [转]</title><link>http://www.cnblogs.com/miaomiaoga/archive/2009/11/12/1592174.html#1696300</link><dc:creator>Benny Ng</dc:creator><author>Benny Ng</author><pubDate>Thu, 12 Nov 2009 03:49:45 GMT</pubDate><guid>http://www.cnblogs.com/miaomiaoga/archive/2009/11/12/1592174.html#1696300</guid><description><![CDATA[你就好了，我用的是RHEL，都不知道怎么来搞定install kernel-PAE呢，我也是刚学的，有招不？<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/miaomiaoga/" target="_blank">Benny Ng</a> 2009-11-12 11:49 <a href="http://www.cnblogs.com/miaomiaoga/archive/2009/11/12/1592174.html#1696300#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:CentOS 挂载可写NTFS分区 [转]</title><link>http://www.cnblogs.com/miaomiaoga/archive/2009/11/08/1592174.html#1692240</link><dc:creator>earl86</dc:creator><author>earl86</author><pubDate>Sat, 07 Nov 2009 20:00:52 GMT</pubDate><guid>http://www.cnblogs.com/miaomiaoga/archive/2009/11/08/1592174.html#1692240</guid><description><![CDATA[哥们，太爱你了。终于解决了。俺一新手。<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/miaomiaoga/" target="_blank">earl86</a> 2009-11-08 04:00 <a href="http://www.cnblogs.com/miaomiaoga/archive/2009/11/08/1592174.html#1692240#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:SQL 发邮件</title><link>http://www.cnblogs.com/miaomiaoga/archive/2009/11/03/1371308.html#1688597</link><dc:creator>Benny1</dc:creator><author>Benny1</author><pubDate>Tue, 03 Nov 2009 03:37:13 GMT</pubDate><guid>http://www.cnblogs.com/miaomiaoga/archive/2009/11/03/1371308.html#1688597</guid><description><![CDATA[Here is the source code...


===============================================
CREATE PROCEDURE sp_SMTPemail
(
@From as nvarchar(50)
,@To as nvarchar(50)
,@Subject as nvarchar(255)
,@Body as text
) --WITH ENCRYPTION--
AS
-- Declare
DECLARE @message int
DECLARE @config int
DECLARE @hr int
DECLARE @src varchar(255), @desc varchar(255)
SET @hr = 0

EXEC @hr = sp_OACreate 'CDO.Message', @message OUT -- create the message
object
EXEC @hr = sp_OACreate 'CDO.Configuration', @config OUT -- create the
configuration object
-- Configuration Object
EXEC @hr = sp_OASetProperty @config, 'Fields(cdoSendUsingMethod)',
'cdoSendUsingPort' -- Send the message using the network
EXEC @hr = sp_OASetProperty @config, 'Fields(cdoSMTPServer)',
'your.server.com' -- SMTP Server
EXEC @hr = sp_OASetProperty @config, 'Fields(cdoSMTPServerPort)', 25 --
Server SMTP Port
EXEC @hr = sp_OASetProperty @config, 'Fields(cdoSMTPAuthenticate)',
'cdoAnonymous' -- Anonymous SMTP Authenticate
EXEC sp_OAMethod @config, 'Fields.Update'
-- Message Object
EXEC @hr = sp_OASetProperty @message, 'Configuration', @config -- set
message.configuration = config
EXEC @hr = sp_OASetProperty @message, 'To', @To
EXEC @hr = sp_OASetProperty @message, 'From', @From
EXEC @hr = sp_OASetProperty @message, 'Subject', @Subject
EXEC @hr = sp_OASetProperty @message, 'bodyformat',0
EXEC @hr = sp_OASetProperty @message, 'MailFormat',0
EXEC @hr = sp_OASetProperty @message, 'HTMLBody', @Body
EXEC sp_OAMethod @message, 'Send()'
-- Destroys the objects
EXEC @hr = sp_OADestroy @message
EXEC @hr = sp_OADestroy @config

-- Errorhandler
IF @hr &lt;&gt; 0
BEGIN
EXEC sp_OAGetErrorInfo @message, @src OUT, @desc OUT
SELECT hr=convert(varbinary(4),@hr), Source=@src, Description=@desc
-- log and/or handle the error here if there is one...
RETURN
END
GO<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/miaomiaoga/" target="_blank">Benny1</a> 2009-11-03 11:37 <a href="http://www.cnblogs.com/miaomiaoga/archive/2009/11/03/1371308.html#1688597#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:CruiseControl.NET持续集成实践</title><link>http://www.cnblogs.com/miaomiaoga/archive/2009/07/27/1507571.html#1597239</link><dc:creator>xiaosonl</dc:creator><author>xiaosonl</author><pubDate>Mon, 27 Jul 2009 15:36:33 GMT</pubDate><guid>http://www.cnblogs.com/miaomiaoga/archive/2009/07/27/1507571.html#1597239</guid><description><![CDATA[很详细很牛B 非常感谢<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/miaomiaoga/" target="_blank">xiaosonl</a> 2009-07-27 23:36 <a href="http://www.cnblogs.com/miaomiaoga/archive/2009/07/27/1507571.html#1597239#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:http 500内部服务器错误</title><link>http://www.cnblogs.com/miaomiaoga/archive/2009/07/22/258207.html#1592821</link><dc:creator>茇</dc:creator><author>茇</author><pubDate>Wed, 22 Jul 2009 11:12:01 GMT</pubDate><guid>http://www.cnblogs.com/miaomiaoga/archive/2009/07/22/258207.html#1592821</guid><description><![CDATA[还可以，不知道有没有用<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/miaomiaoga/" target="_blank">茇</a> 2009-07-22 19:12 <a href="http://www.cnblogs.com/miaomiaoga/archive/2009/07/22/258207.html#1592821#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item></channel></rss>
