使用T-SQL中具有常量值的新列插入来自不同表的值

I am inserting all values from a table into another table, which is created on the fly. I want to insert one extra column with constant value to the new table I create. I am inserting all values from a table into ano