title: SET datatype set in SQL Server
body: <p>While creating a table I have to use the datatype <code>SET</code>, but it looks like there is no datatype <code>SET</code> in SQL Server. I was looking on the Microsoft's website and those are the datatypes that it supports: <a href="http://msdn.microsoft.com/en-us/library/ms187752.aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/ms187752.aspx</a></p>
  
  <p>Which one should I use to replace the <code>SET</code>?</p>
  
  <p>I have used <code>SET</code> in MySQL database like this:</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS `configurations` (
  `index` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `configDuration` int(5) NOT NULL,
  `configDurationPerspective` set('list_this_day','list_remaining') NOT NULL,
  PRIMARY KEY (`index`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=latin1;
  </code></pre>
  
  <p>And then when I insert data into the table it looks like this:</p>
  
  <pre><code>INSERT INTO 'configurations' (index, user_id, configDuration, configDurationPerspective) VALUES (1, 1, 2, 'list_this_day');
  </code></pre>
  
  <p>Never mind the quotes. Something messed up while pasting the code.</p>
  
  <p>Now I want to do the same thing, but in SQL Server.</p>