Format Sp

dineshasanka

How can I format this with parameters for each line

[b]EXECUTE msdb.dbo.sp_send_dbmail @profile_name = 'Send Customer Order Notification',@recipients = [url='somebody@somewhere.com]'somebody@somewhere.com[/url]',@body = 'Thank you for you Order ',@subject = 'Order conformation'[/b]

Andras B

dineshasanka wrote:

How can I format this with parameters for each line

[b]EXECUTE msdb.dbo.sp_send_dbmail @profile_name = 'Send Customer Order Notification',@recipients = [url='somebody@somewhere.com]'somebody@somewhere.com[/url]',@body = 'Thank you for you Order ',@subject = 'Order conformation'[/b]

In the current version we only wrap exec statements. We will consider adding this option in future releases. Many thanks for reporting this.

Regards,
Andras

tgoldstein@co.arapahoe

I would second formatting execute statements in the future.

Tim
Denver, CO