title: Set 0 instead of null with SQL query in SQL Server (C#)
body: <p>I have a table with 500 columns, and many of these are null, also I can not change the database.</p>
  
  <p>It's a shared project.</p>
  
  <p>My problem is null, I would need to put 0 instead of null, but they are obliged to do so in the query.</p>
  
  <p>I tried with:</p>
  
  <pre><code>SELECT isnull(mycolumn, 0) 
  FROM RGP_RegistrazioneParametri 
  WHERE RGP_MCC_Numero_Serie_MS = xxxx
  </code></pre>
  
  <p>but without success .... in this instance I should put the name for the column, and since they are 500 columns, I ask ... there is a method to do this automatically on all null?</p>
  
  <p>Thank you.</p>