Posted by othellomy on 11/15/06 07:28

It will use compiled plan.

Thyagu wrote:
> Hi,
>
> If one uses a temporary table/ table variable within a stored
> procedure, will it use the compiled plan each time the stored procedure
> is executed or will it recompile for each execution?
>
> Thanks in advance,
> Thyagu

• Next in forum: newbie: telnet localhost 1433 fails
• Prev in forum: Re: SQL to calculate surrounding suburbs
• Thread view: Re: Using temporary tables within the stored procedure

[Reply to this message]