Converting the NULL Properties of a Target Column with select...into

Use the convert command to change the nullability of a target column into which you are selecting data.

For example, the following selects data from the titles table into a target table named temp_titles, but converts the total_sales column from null to not null:
select title, convert (char (100) not null, total_sales)
total_sales
into #tempsales
from titles