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 |
How to confgiure sccm in AD for synchronization
What is the contract attribute of the <endpoint> element?
What is Server ?
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?
What are the new features in visual studio 2017?
Which language is used in microsoft?
What is refactoring?
How is xaml used? : xaml
What is product key in microsoft?
Does microsoft have a virus protection?
Do you know about dll hell? Explain it?
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)