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?
- 1 Answers
- 3528 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is microsoft's web browser?
Is the server set up the client address or the client set it up in the duplex communication ? Server uses This address to sent the data back to the client.
What is the functionallity difference between radio/option buttons and a drop-down list box besides appearence? i.e. When it is better to use one instead of the other?
Do I need microsoft visual c++ 2005 redistributable?
How does xaml relate to other web service standards? : xaml
What is the name attribute of the
How do you interact with git in visual studio?
What is SMTP (Simple Mail Transfer Protocol) ?
Why do we need xaml? : xaml
What are the four microsoft programs?
What is microsoft exchange used for?
What is difference between microsoft edge and internet explorer?
How do I stop microsoft teams from opening on startup?
What is Spyware ?
What is Uninstall?
