title: Insert null value into SQL Server database
body: <p>I have this code </p>
  
  <pre><code>public void insertAssignment(long mediaEvent_ID, long mediaBranch_ID,
  int? isPremiere, int? isNew, int? isLastChance, 
  int? isPrevShown, int season_ID, int? audio_ID, 
  int? video_ID, DateTime startdate)
  {
      query = "insert into Assignment Values(" + mediaEvent_ID+ "," 
      + mediaBranch_ID + "," + isPremiere + "," + isNew + "," 
      + isLastChance + "," + isPrevShown
      + "," + season_ID + "," + audio_ID + "," + video_ID + ",'" +  
      startdate.ToString("MM/dd/yyyy") + ")";   }
  </code></pre>
  
  <p>I have a problem while insert if any attribute is null like <code>isPremiere=null</code> problem 
  is <code>insert {values(mediaEvent,mediaBranch,(is empty not contains a values ),......)}</code></p>
  
  <p>How can I resolve this problem?</p>