Skip to Content
0
Former Member
Aug 12, 2014 at 09:16 PM

Is there a way to add a new line (line feed) while inserting values into a table

3132 Views

I am trying to keep track of all the inputs(kind of a log) when someone calls a stored procedure. I want a record in an input column in a log table to look something like this :

1.

input1 : xxxx

input2 : xxxx

input3 : xxxx

and so on

instead of inserting in a single line like

2.

input1 : xxxx ; input2 : xxxx ; input3 : xxxx ;

No particular reason but the former looks way better and also easier when i have to go through logs for suspicious inputs.

So, is there a way to insert a newline character (\n) or any other way to achieve this.

Thank you.