Interested to Buy Any Domain ? << Click Here >> for more details...
can u tel me how we can use temp table in sql sserver
instead of Dual in oracle?
- 1 Answers
- 3631 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is the cycle of Installing patches.....
Is microsoft visio viewer free?
Explain how many data types are supported in vbscript?
How does xaml relate to business process modeling languages (ebxml business process, bpml)? : xaml
What is Script file ?
Where are microsoft mail files stored?
What language is microsoft office written in?
Why user and kernel mode are good designed operating system?
What is Spam ?
What is the purpose of a microsoft account?
What is Upload
What is Docking Station ?
Where is microsoft notepad located?
Because of virus in windows 7 my general folders are system hidden now. i've remove the virus but folders are still hidden. can i make that system hidden folder as nornal any how?
Do you know about dll hell? Explain it?
