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