What are the challenges you face when working across database platforms? Take the survey
Options

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:

Comments

  • Options
    Andras BAndras B Posts: 249
    edited August 1, 2017 12:38PM
    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.
  • Options
    I would second formatting execute statements in the future.

    Tim
    Denver, CO
Sign In or Register to comment.