How so select a value into a table, if the source table does not contain the value
I am selecting data from a temp table "#TEMP_TABLE" into another table "ADMIN_USERS" which is not temporary.
The temp table does not have one of the column values I need to insert into the database table "ADMIN_USERS".
The column that is missing from the temp table is named "SERVER_NAME", and is a non null field. I would like to just insert the word/name
"Practice Server" into this field. How can I do that? Can it be done in the select statement?
INSERT INTO ADMIN_USERS (
SERVER_NAME -- Somehow set this field to the text "Practice Server". I don't know how to do it though??.