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?

Question Posted / msmnithya

1 Answers
3210 Views
I also Faced
E-Mail Answers

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

hi i want to retrieve the data from one spread sheet to another workbook in EXCEL VBA. for exmp:customer details first name last name location state country country code mobile customer details raj krishna hyderabad andhra india 91 0 service required refrigirator company color details cost warranty service required samsung silver double door fridge 45000 3yeras

0 Answers TechSoft,

Diff.. between cursor and Reference Cursor?

1 Answers

What is Port Forwording?

0 Answers Quexst,

Can you tell what is the purpose of user32.dll?

0 Answers C DAC, CDAC,

Where was microsoft founded?

0 Answers

Enumerate the high level elements of the <system.serviceModel> section

1 Answers

What is SMTP (Simple Mail Transfer Protocol) ?