title: SQL Server : newline character
body: <p>I have a programming language that does not allow me to write queries on multiple lines. It has to be written all in a single line.</p>
  <p>I am unable to send a <code>GO</code> command because it has to be in a new line..</p>
  <p>So for example, this does not work:</p>
  <pre><code>insert into mytable (field1, filed2) values (1, 2), (3, 4); go
  </code></pre>
  <p>as it should be</p>
  <pre><code>insert into mytable (field1, filed2) values (1, 2), (3, 4); 
  go
  </code></pre>
  <p>I've tried multiple things but none worked:</p>
  <pre><code>insert into mytable (field1, filed2) values (1,2),(3,4); \r go
  
  insert into mytable (field1, filed2) values (1,2),(3,4); \r\n go
  
  insert into mytable (field1, filed2) values (1,2),(3,4); $r$n go
  
  insert into mytable (field1, filed2) values (1,2),(3,4); char(10) go
  
  insert into mytable (field1, filed2) values (1,2),(3,4); char(13) go
  </code></pre>
  <p>Is there a way to write it inline, and have SQL Server use it as 2 different lines?</p>