Printing Table Results to Email Message

• ckmoied

  Ten Centuries

  Points: 1092

  More actions

  November 13, 2007 at 3:24 am

  #75811

  Hi All,

  Can I print the results of a table directly to an email message. If yes, how ?

  Otherwise, whats the query statement to print the table results to a text file.

  Like

  Select * from #TransData to a text file rather than the screen.

• Jez-448386

  SSCarpal Tunnel

  Points: 4594

  More actions

  November 13, 2007 at 3:39 am

  #750543

  Have a look at xp_sendmail in Books on Line.

  Jez