title: ISNULL with SQL Server 2008
body: <p>I want to use <code>ISNULL</code> with all columns of a table.</p>
  
  <p>Like this </p>
  
  <pre><code>SELECT ISNULL(* , 'NA') FROM #tbl 
  </code></pre>
  
  <p>I know its a wrong way I have to specify each column name separately to use <code>ISNULL</code>.</p>
  
  <p>But in my case <code>#tbl</code> is a temporary table and columns are created dynamically </p>
  
  <p>like this:</p>
  
  <pre><code>EXEC ('ALTER TABLE #tbl ADD [' + @bno + '] varchar(30)')
  </code></pre>
  
  <p>Due to this I can't use column names in select query because column names are always different.</p>
  
  <p>So what should I do?</p>