tsql - Create a nullable column using SQL Server SELECT INTO? -


When I create a template table using a in SQL Server, there is a way Is there any column that should be blank? I have a multi-step process, where I am creating a floating table by selecting multiple columns (this is why I am not making table #tmp (...) ). After creating that Temple table, I am updating some columns and some of those updates may be out of the field.

I know that I can do a option table opener column statement what I want, but I'm curious about whether to select it I know that you can inline your column to get the desired datatype, but I can not see how you define persistence.

Comments