New line character passed through SQL

WCOMAB / SqlServerSlackAPI

SqlServerSlackAPI is a SQL Server CLR assembly for direct communication with Slack via TSQL

Microsoft Public License

29 stars 7 forks source link

New line character passed through SQL #6

Open ghost opened 6 years ago

ghost commented 6 years ago

Hi,

I was hoping someone could explain how to pass a newline character in the SQL msg. I tried '\n', '/n' etc. but it is not passing through to Slack. How to do create a new paragraph in my message?

Thanks, Testerman

devlead commented 6 years ago

You should be able to just do a line break like

SELECT N'Line 1
Line 2'