Pergunta de entrevista da empresa Xceedance

Q. If there are temporary tables with same name in different databases, can those be accessed in same query window?

Respostas da entrevista

Sigiloso

21 de dez. de 2018

Ans. I answered: Temporary tables are stored only in one database i.e. tempdb. Still the interviewer was asking irrelevant scenarios.

Sigiloso

9 de out. de 2019

No, because temporary table only exists in temp db

Sigiloso

12 de out. de 2019

Interviewer asked, "but if temporary table exists in different databases, can both be accessed in same query window?"