Is it necessary to use # before creating a temporary table in SQL server?
Example:
SELECT column1, column2, someInt, someVarChar
INTO ItemBack1
FROM table2
WHERE table2.ID = 7
For ItemBack1 is it necessary to use the # symbol?
If not, then what is the use of # in creating temp tables?