ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Microsoft Related  >>  Microsoft Related AllOther
 
 


 

 
 Visual Basic interview questions  Visual Basic Interview Questions
 C Sharp interview questions  C Sharp Interview Questions
 ASP.NET interview questions  ASP.NET Interview Questions
 VB.NET interview questions  VB.NET Interview Questions
 COM+ interview questions  COM+ Interview Questions
 ADO.NET interview questions  ADO.NET Interview Questions
 IIS interview questions  IIS Interview Questions
 MTS interview questions  MTS Interview Questions
 Crystal Reports interview questions  Crystal Reports Interview Questions
 BizTalk interview questions  BizTalk Interview Questions
 Dot Net interview questions  Dot Net Interview Questions
 Exchange Server interview questions  Exchange Server Interview Questions
 SharePoint interview questions  SharePoint Interview Questions
 Microsoft Related AllOther interview questions  Microsoft Related AllOther Interview Questions
Question
can u tel me how we can use temp table in sql sserver
instead of Dual in oracle?
 Question Submitted By :: Msmnithya
I also faced this Question!!     Rank Answer Posted By  
 
  Re: can u tel me how we can use temp table in sql sserver instead of Dual in oracle?
Answer
# 1
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
Rajesh K Gupta
 

 
 
 
Other Microsoft Related AllOther Interview Questions
 
  Question Asked @ Answers
 
can u tel me how we can use temp table in sql sserver instead of Dual in oracle?  1
Perform the following tasks using MS-EXCEL: FUEL ESTIMATES COMPUTATIONS: This project is to compute the fuel needed for two types of airplanes, and the cost of the fuel. You must do all computations using formula, and do a chart. Use Page Setup to make the left margin 0.5 and the right margin 0.5 also. Put your name in the Title line, after "Fuel Estimates". Note the following: ? Col. D - H: You must enter correct formulas under Columns D through H (Flying Fuel, Reserve Fuel, Holding Fuel, Total Fuel Needed and Estimated Fuel Cost)!! Read and compute carefully! ? Cells C12, C13, C14, H13 or H14: When you use these cells in a formula, you must make them absolute cell references (F4 key after your type the cell reference, or enter the $ sign manually) ? Graph/Chart: Select cells A3:B8 (Plane and Flight). Hold down the "Control" key and select D3:D8. Hold down the "Control" key and select G3:G8. Create a chart (Insert- Chart, Finish) and position it in a pleasing way under the data for the flight. Print it on one sheet, in landscape mode. ? Print again, but with Formulae: There are two ways to show formulas: 1) Enter Control+` (the key with the ~ at the top left) or 2) Tools-Options, and under "Window Options" put a check mark beside "Formulas", then close the window. San2
In excel,how to clear the values of the cell without removing the formula?  1
how to create assembly? Nth-Solution1
What’s the difference between forward lookup and reverse lookup in DNS? DynPro6
xp professional operating system is showing virtual memory too low?  2
Diff.. between cursor and Reference Cursor?  1
i need some windows short keys than run command also. if any body knows send website address.  1
What is the Drawback of DHCP?  2
What are FMSO Roles? List them... DynPro4
how to install visual studio 2005 for web development plz tell me the steps of it and data base too  1
What is the Difference between Edit and Modify. Anybody can explain it with example....  2
What is the difference between Win2k Server and Win2k3? Wipro4
What is Kerberos? Which version is currently used by Windows? How does Kerberos work? IBM1
What is the difference between procedures and functions in C3#.NET Tentacle-Technologies2
what options in dhcp do you regularly use in microsoft network  1
How intra site replication works..is it through KCC or RPC over IP. HP2
i face a big prob in ms outlook 2k3 when i send a mail to others person but when go to sent itms there not show cc & To format whats prob how to trouble it?Plz reply hurry  4
hi iam using window 2003 server,in that iam using remote instalation service (instaling oparating system through remotely) in my client machine gave a error like "the network adaptor is not present in your image " pls send me solution as soon as possible  1
 
For more Microsoft Related AllOther Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com