title: How to create a column name with space in SQL Server
body: <p>I want to create a column with a space in its name. In MySQL I just created this using back ticks, but in SQL Server that causes an error. Are there any possibilities to create a column name with a space?</p>
  
  <p>I've tried the following but it doesn't work.</p>
  
  <pre><code>create table space_check
  (
  `roll num` int,
  name varchar(50)
  )
  </code></pre>
  
  <p>Can anybody tell me how to create this?</p>