can u tel me how we can use temp table in sql sserver
instead of Dual in oracle?
- 1 Answers
- 2696 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 the difference between the SoapUi utility and the VS2008 test functionality used for the Web-service testing?
How to recover a failed RAID-5 Controlled HDD
What is product key in microsoft?
What is DS Proxy?
What microsoft means?
How do I sign in without a microsoft account?
Can you tell what is the purpose of user32.dll?
i need some windows short keys than run command also. if any body knows send website address.
What is DDR (Double Data Rate)
How do I access my microsoft account?
what is 'macro' in excel? how to make use of it ?
What is Telnet
-
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)
