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?..

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

Where is microsoft notepad located?

1 Answers  


Explain why do we use option explicit?

1 Answers  


What is the relationship between xaml and jts/jta? : xaml

1 Answers  


What is Domain ?

1 Answers  


What is the difference between microsoft edge and internet explorer?

1 Answers  


What are FMSO Roles? List them...

4 Answers   DynPro,


How do I sign in without a microsoft account?

1 Answers  


i need some windows short keys than run command also. if any body knows send website address.

2 Answers  


What standards body will xaml be submitted to? : xaml

1 Answers  


What is SNMP ?

1 Answers   CTS,


What is Root ?

2 Answers   CMS,


What are microsoft tools?

1 Answers  


Categories