Re: #Temp table question
From: MichaelK (michaelk_at_gomobile.com)
Date: 01/02/05
- Previous message: Hugo Kornelis: "Re: #Temp table question"
- In reply to: Hugo Kornelis: "Re: #Temp table question"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 1 Jan 2005 22:40:35 -0800
Thanks Hugo.
You were helpfull as well as with my another question.
It's what I was looking for.
Regards,
Michael
"Hugo Kornelis" <hugo@pe_NO_rFact.in_SPAM_fo> wrote in message
news:ej7et0980uvbk8n3nheabcvn0lfq57as4a@4ax.com...
> On Fri, 31 Dec 2004 16:12:06 -0800, MichaelK wrote:
>
>>I'm not sure if I understood this correctly.
>>If I create a temporary table with the name #SomeTempTab,
>>can anybody else see this table while I'm using it and before I drop it.
>>So if two users at the same time trying to create the table with this name
>>will they be different for each user or there will be a conflict?
>
> Hi Michael,
>
> There will be no conflict. SQL Server will generate a connection-specific
> suffix to create a really unique table name in tempdb. Everytime you refer
> to #SomeTempTab, SQL Server will append the suffix and look in "your"
> version of the temporary table.
>
> Best, Hugo
> --
>
> (Remove _NO_ and _SPAM_ to get my e-mail address)
- Previous message: Hugo Kornelis: "Re: #Temp table question"
- In reply to: Hugo Kornelis: "Re: #Temp table question"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
