title: Insert statement with a NON-NULLABLE column
body: <p>I have a SQL Server script that I'm using to insert some data into a database. I won't upload the whole script here just for space/time savings sake, but I will include the important bits. </p>
  
  <p>So here is the problem. I have a table that has a column for some <code>loginhtml</code>, this column is of a non-nullable type. I would like for this column to be left blank on this particular add so it can default back to the parent that I'm pointing it at. So here we have the declaration for this important portion:</p>
  
  <pre><code>declare @loginTitle varchar(250), @loginHtml varchar(max)
  </code></pre>
  
  <p>And here we have what it will be set to:</p>
  
  <pre><code>set @loginHtml = null
  </code></pre>
  
  <p>And here is the insert part that is inevitably going to fail:</p>
  
  <pre><code>insert dbo.ApplicationLogin(ApplicationID, Title, Html)
     select @appID, @loginTitle, @loginHtml
  </code></pre>
  
  <p>EDIT: How can I have this script "default" the loginhtml column to whatever the PARENT Application is? Is there some "IF" statement/clause that can be used to accomplish this?</p>