dshi15
asked on
Sql server temp table
Hi Expert,
select * into tmpBusLine from BusinessLine
Is tmpBusLine a temp table? What is different between it with #tmpBusLine and what its scope?
Thanks in advance.
select * into tmpBusLine from BusinessLine
Is tmpBusLine a temp table? What is different between it with #tmpBusLine and what its scope?
Thanks in advance.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I should say 'you mean tmpBusLine is not temporary table?'
tmpBusLine - physical table
@tmpBusLine - table variable
#tmpBusLine - temporary table which can be accessed in the query window. When you close the window, the table will be destroyed. Tis table resides in session of sql server
@tmpBusLine - table variable
#tmpBusLine - temporary table which can be accessed in the query window. When you close the window, the table will be destroyed. Tis table resides in session of sql server
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER