title: Difference between WITH NOCHECK CHECK CONSTRAINT and CHECK CONSTRAINT
body: <p>What is the difference between these scripts?</p>
  
  <pre><code>ALTER TABLE Post_Send WITH NOCHECK CHECK CONSTRAINT [My_FOREIGN_KEY];  
  GO
  
  ALTER TABLE Post_Send CHECK CONSTRAINT [My_FOREIGN_KEY];
  GO
  </code></pre>