Guest User

Untitled

a guest
May 10th, 2018
331
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.37 KB | None | 0 0
  1. @body_text=N'SELECT TOP 100 * FROM payhistory WHERE entered BETWEEN
  2. DATEADD(wk,DATEDIFF(wk,7,GETDATE()),0)
  3. AND DATEADD(wk,DATEDIFF(wk,7,GETDATE()),4) AND desk=020 ORDER BY entered
  4. DESC
  5.  
  6. exec master.dbo.xp_smtp_sendmail
  7. @server = 'server',
  8. @from = 'administrator@mydomain.com',
  9. @to = 'me@mydomain.com',
  10. @subject = 'HTML Testing...',
  11. @type = 'text/html',
  12. @message = @body_text
  13.  
  14. @body_text=N'SELECT TOP 100 * FROM payhistory WHERE entered BETWEEN
  15. DATEADD(wk,DATEDIFF(wk,7,GETDATE()),0)
  16. AND DATEADD(wk,DATEDIFF(wk,7,GETDATE()),4) AND desk=020 ORDER BY entered
  17. DESC';
  18.  
  19. exec master.dbo.xp_smtp_sendmail
  20. @server = 'server',
  21. @from = 'administrator@mydomain.com',
  22. @to = 'me@mydomain.com',
  23. @subject = 'HTML Testing...',
  24. @type = 'text/html',
  25. @message = @body_text;
  26.  
  27. EXEC xp_sendmail @recipients = 'recipients'
  28. , @message = 'message'
  29. , @query = 'query'
  30. , @attachments = 'attachments ;...n '
  31. , @copy_recipients = 'copy_recipients ;...n '
  32. , @blind_copy_recipients = 'blind_copy_recipients ;...n '
  33. , @subject = 'subject'
  34. , @type = 'type'
  35. , @attach_results = 'attach_value'
  36. , @no_output = 'output_value'
  37. , @no_header = 'header_value'
  38. , @width = width
  39. , @separator = 'separator'
  40. , @echo_error = 'echo_value'
  41. , @set_user = 'user'
  42. , @dbuse = 'database'
Add Comment
Please, Sign In to add comment