remove allow nulls from column in SELECT INTO statement
I am working with SQL Server 2008 and am trying to create a table from another table using a SELECT INTO statement. The only problem I am having is, I need to make sure the column does not allow null values. As it is, when I run my query, all the columns allow nulls. Is there a way to create the columns so that they do not allow nulls?
SELECT CAST(REPLACE(id,'"','') as INT) as idINTO newtableFROM oldtable