Format Sp

dineshasankadineshasanka Posts: 208
edited August 1, 2017 12:38PM in SQL Refactor Previous Versions
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]
Tagged:
· Share on Twitter

Comments

  • Andras BAndras B Posts: 249
    edited August 1, 2017 12:38PM
    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
    András Belokosztolszki, PhD
    Red Gate Software Ltd.
    · Share on Twitter
  • tgoldstein@co.arapahoetgoldstein@co.arapahoe Posts: 71
    I would second formatting execute statements in the future.

    Tim
    Denver, CO
    · Share on Twitter
Sign In or Register to comment.