Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- @body_text=N'SELECT TOP 100 * FROM payhistory WHERE entered BETWEEN
- DATEADD(wk,DATEDIFF(wk,7,GETDATE()),0)
- AND DATEADD(wk,DATEDIFF(wk,7,GETDATE()),4) AND desk=020 ORDER BY entered
- DESC
- exec master.dbo.xp_smtp_sendmail
- @server = 'server',
- @from = 'administrator@mydomain.com',
- @to = 'me@mydomain.com',
- @subject = 'HTML Testing...',
- @type = 'text/html',
- @message = @body_text
- @body_text=N'SELECT TOP 100 * FROM payhistory WHERE entered BETWEEN
- DATEADD(wk,DATEDIFF(wk,7,GETDATE()),0)
- AND DATEADD(wk,DATEDIFF(wk,7,GETDATE()),4) AND desk=020 ORDER BY entered
- DESC';
- exec master.dbo.xp_smtp_sendmail
- @server = 'server',
- @from = 'administrator@mydomain.com',
- @to = 'me@mydomain.com',
- @subject = 'HTML Testing...',
- @type = 'text/html',
- @message = @body_text;
- EXEC xp_sendmail @recipients = 'recipients'
- , @message = 'message'
- , @query = 'query'
- , @attachments = 'attachments ;...n '
- , @copy_recipients = 'copy_recipients ;...n '
- , @blind_copy_recipients = 'blind_copy_recipients ;...n '
- , @subject = 'subject'
- , @type = 'type'
- , @attach_results = 'attach_value'
- , @no_output = 'output_value'
- , @no_header = 'header_value'
- , @width = width
- , @separator = 'separator'
- , @echo_error = 'echo_value'
- , @set_user = 'user'
- , @dbuse = 'database'
Add Comment
Please, Sign In to add comment