Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?



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

How to confgiure sccm in AD for synchronization

2 Answers   Baidu, JDA, Wipro,


What is the contract attribute of the <endpoint> element?

0 Answers  


What is Server ?

2 Answers  


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,


Who owns microsoft now?

0 Answers  


What are the new features in visual studio 2017?

0 Answers  


Which language is used in microsoft?

0 Answers  


What is refactoring?

0 Answers  


How is xaml used? : xaml

0 Answers  


What is product key in microsoft?

0 Answers  


Does microsoft have a virus protection?

0 Answers  


Do you know about dll hell? Explain it?

0 Answers  


Categories