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
- 3527 Views
- I also Faced
- E-Mail Answers
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 |
What is WAN (Wide Area Network) ?
Is it possible to log the messages on the service side? On the client side? How to switch on the logging?
What kind of applications will xaml enable? : xaml
How to create virtual root in iis?
What is different between VMware and HyperV?
Do you have to pay for microsoft edge?
How do I get my microsoft store back?
Is microsoft shutting down?
What is DNS (Domain Name System)
What is the difference between procedures and functions in C3#.NET
2 Answers Tentacle Technologies,
What is UDP (User Datagram Protocol)?
What are the different refactoring options in visual studio?
-
Visual Basic (800) - C Sharp (3816)
- ASP.NET (3180)
- VB.NET (461)
- COM+ (79)
- ADO.NET (717)
- IIS (369)
- MTS (11)
- Crystal Reports (81)
- BizTalk (89)
- Dot Net (2435)
- Exchange Server (362)
- SharePoint (720)
- WCF (340)
- MS Office Microsoft (6963)
- LINQ Language-Integrated Query (317)
- WPF (371)
- TypeScript (144)
- Microsoft Related AllOther (311)
