can u tel me how we can use temp table in sql sserver instead of Dual in oracle

can u tel me how we can use temp table in sql sserver
instead of Dual in oracle?

Question Posted / msmnithya

1 Answers
2670 Views
I also Faced
E-Mail Answers

can u tel me how we can use temp table in sql sserver instead of Dual in oracle?..

Answer / rajesh k gupta

Temp Table whether it is local temp which is naming with
single # or global with ## is stored in tempdb database.
it can be seen by exploring the databsse. if it is local
temp table it would be droped once user ends the session,
so you will have to ensure that you are using this table in
the same session where it has been created.
Sysntax to retrieve data frm a temp table is as follows:-
select field1,field2.....fieldN from #tablename

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Microsoft Related AllOther Interview Questions

Are the addresses, the bindings, the contracts unique between services?

0 Answers

what is DHCP & DNS port number?

17 Answers CMS, TCS,

What is Root ?

2 Answers CMS,

What is Server ?