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
- 3672 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 Docking Station ?
Can a microsoft office product key be used twice?
What the difference between the SoapUi utility and the VS2008 test functionality used for the Web-service testing?
What is the use of the code definition window in visual studio?
active directory
what are the command utility 's using in fail over cluster?
What is Root ?
What is microsoft compatibility telemetry?
What is the difference between microsoft edge and internet explorer?
what is site link?
xp professional operating system is showing virtual memory too low?
How do I sign in without a microsoft account?
-
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)
