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
- 3743 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
Can you explain about browser link?
While server generating the patches . that time server pull or push the resources?
How is xaml used? : xaml
Is microsoft defender free?
What is the relationship between xaml and jts/jta? : xaml
How does xaml relate to other web service standards? : xaml
How do I permanently delete microsoft teams?
Why do we need xaml? : xaml
Which language is used in microsoft?
What is Spam ?
Is there a charge for microsoft?
What is a solution explorer in visual studio?
How does xaml relate to registries (uddi)? : xaml
What is Uninstall?
How to use script on Domain ?
