can u tel me how we can use temp table in sql sserver
instead of Dual in oracle?
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 Splitter?
What is microsoft c register server?
how to convert additional domain to primary domain controller on windows 2003 server
How intra site replication works..is it through KCC or RPC over IP.
Explain difference between dim object as object and dim obj as myform?
How do I turn off microsoft telemetry compatibility?
Is windows a microsoft product?
Is there any other options to create a site definition for MOSS other than using onet.xml.
What is the relationship between xaml and other transaction protocols? : xaml
Where was microsoft founded?
Is there a charge for microsoft?
What is URL Forwarding ?
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)