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 |
Where is microsoft notepad located?
Explain why do we use option explicit?
What is the relationship between xaml and jts/jta? : xaml
What is Domain ?
What is the difference between microsoft edge and internet explorer?
What are FMSO Roles? List them...
How do I sign in without a microsoft account?
i need some windows short keys than run command also. if any body knows send website address.
What standards body will xaml be submitted to? : xaml
What is SNMP ?
What is Root ?
What are microsoft tools?
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)