title: How to add multiple columns to a table and add default constraint on one of them?
body: <p>I want to add 2 new columns to existing table.</p>
  
  <p>One of them should be <code>NOT NULL</code> with default value <em>0</em>
  (filled in the existing rows as well).</p>
  
  <p>I have tried the following syntax:</p>
  
  <pre><code>Alter TABLE dbo.MamConfiguration
      add [IsLimitedByNumOfUsers] [bit]  NOT NULL,
      CONSTRAINT IsLimitedByNumOfUsers_Defualt [IsLimitedByNumOfUsers] DEFAULT 0
      [NumOfUsersLimit] [int] NULL
  go
  </code></pre>
  
  <p>But it throws exception. How should I write it?</p>