title: Create a nullable column using SQL Server SELECT INTO?
body: <p>When I create a temp table using a <code>select into</code> in SQL Server, is there a way to specify that a column should be nullable?  I have a multi-step process where I'm making a temp table by selecting a lot of columns (which is why I'm not doing a <code>create table #tmp (...)</code>).  After I make that temp table, I'm updating some columns and some of those updates might null out a field.</p>
  
  <p>I know I could do an <code>alter table alter column</code> statement to achieve what I want, but I'm curious about whether there's a way to specify this in the <code>select</code> itself.  I know you can inline <code>cast</code> your columns to get the desired datatype, but I can't see how you specify nullability.</p>