评论会员:游客 时间:2012/02/06
rakeshkumarc:codepreCREATEPROCEDUREdbo.mailsndASBEGINSETNOCOUNTON--spanclass="code-keyword"do/spansomeotheractionsDECLARE@bodyVARCHAR(spanclass="code-digit"1024/span)SET@body=spanclass="code-string"'/spanspanclass="code-string"foowasfired'/span+CONVERT(VARCHAR,GETDATE())EXECmaster..xp_sendmail@recipients=spanclass="code-string"'/spanspanclass="code-string"you@you.com'/span,@message=@body,@subject=spanclass="code-string"'/spanspanclass="code-string"mailwasfired.'/spanEND--oryoucanspanclass="code-keyword"do/spanitconditionally:CREATEPROCEDUREdbo.mailsndASBEGINSETNOCOUNTON--spanclass="code-keyword"do/spansomeotheractionIF@@ROWCOUNT>spanclass="code-digit"0/spanBEGINDECLARE@bodyVARCHAR(spanclass="code-digit"1024/span)SET@body=spanclass="code-string"'/spanspanclass="code-string"foowasfired'/span+CONVERT(VARCHAR,GETDATE())+CHAR(spanclass="code-digit"13/span)+CHAR(spanclass="code-digit"10/span)+CONVERT(VARCHAR,@@ROWCOUNT)EXECmaster..xp_sendmail@recipients=spanclass="code-string"'/spanspanclass="code-string"you@you.com'/span,@message=@body,@subject=spanclass="code-string"'/spanspanclass="code-string"mailwasfired.'/spanENDEND/pre/code
deepakdynamite
评论会员:游客 时间:2012/02/06
你好,请看看下面的链接:imgsrc={A}]