can u tel me how we can use temp table in sql sserver
instead of Dual in oracle?



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

Post New Answer

More Microsoft Related AllOther Interview Questions

What is SSL (Secured Sockets Layer) ?

0 Answers  


What is Docking Station ?

0 Answers   Cummins,


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.

3 Answers   Excel, Ignou, San, Softweb,


Why do we need xaml? : xaml

0 Answers  


Why do we need xaml as a new way to create applications in .net framework 3.0 (formerly winfx)? : xaml

0 Answers  






What is domain

6 Answers   HP, Reliance,


What the difference between the request-response pattern and the duplex pattern?

1 Answers  


Is microsoft autoupdate a virus?

0 Answers  


What is the difference in the attributes the binging and the bindingName of the <endpoint> element?

0 Answers   Baidu,


Where is microsoft notepad located?

0 Answers  


Can I uninstall microsoft teams?

0 Answers  


how to auto generate the text box using infopath?

0 Answers   Microsoft,


Categories