title: MSSQL to VB.NET conversion
body: <p>I'm working on a projec which is converting T-SQL procedures into VB.NET code and I've been thinking about how to write something neat, clean in VB.NET. </p>
  
  <p>For example, this is the T-SQL : </p>
  
  <pre><code>insert into X(
   column1, 
   column2, 
   ....., 
   column100) 
  select 
   column1, 
   column2, 
   ....., 
   column100 
   from Y 
  </code></pre>
  
  <p>How should I convert this statement into VB.NET? If I use string builder, it would be something like : </p>
  
  <pre><code>Dim sb As New StringBuilder()
  With sb
      .Append("Insert into x(")
      .Append("column1,")
      .Append("column2,")
      .Append("...,")
      ......
  End With
  </code></pre>
  
  <p>THe code would be too long. Is there any better alternatives? </p>