You are here: Re: Query result sent via e-mail « MsSQL Server « IT news, forums, messages
Re: Query result sent via e-mail

Posted by M A Srinivas on 05/24/07 09:36

On May 24, 12:22 pm, "Marco Garutti" <marco.garu...@tecnoform.com>
wrote:
> Hi all,
> I've a query running under MS SQLServer2000 (Stored Procedures).
> I'd like to send it's result via e-mail, formatting the output in txt form
> or html form.
> Someone knows how to do it ? Have you got examples of code ?
> Thanks for the advice
>
> Marco Garutti

It may be better you can send through excel . Just run the SP in QA
and copy and paste to excel . Zip the excel file and send it to email

Note: Excel has limitation of 65,000 odd rows

If you want in text format , in QA , set output to text with delimiter
of your choice (,or |) and copy and paste to notepad .

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация