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
- 3660 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
Is xaml only used for quick ui prototyping? : xaml
Explain session variables?
What is DLL hell problem?
What languages can you code in visual studio?
What is mfc?
How to recover a failed RAID-5 Controlled HDD
What does microsoft blend do?
What is the contract attribute of the
How is xaml used? : xaml
What are the four microsoft programs?
What is SNMP ?
In which scenario i can use stub zone and why if i have all information in my primary dns server?
How to detect clone code in visual studio?
What is Uninstall?
What is Computer Administrator ?
