how can i insert some query result in the mail

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

how can i insert some query result in the mail

Author

Topic

boreddy
Posting Yak Master

172 Posts

Posted - 2008-08-20 : 00:17:50

i write stored procedure for sending mail.. it's coming test mail
i want to insert some query result in the mail ...i dont know how to do

please help me

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-08-20 : 00:35:56

you can use query option in sp_send_dbmail in sql 2005 or xp_sendmail in sql 2000.

xp_sendmail
http://msdn.microsoft.com/en-us/library/ms189505.aspx

sp_send_dbmail
http://msdn.microsoft.com/en-us/library/ms190307.aspx

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources