>>>my statement: The go statement clears all temp variables... Your statement: That's not true.
>>>
>>>
>>>
>>>Rest my case..
>>
>>Temp variables is somewhat ambigious statement. If you would just say 'variables', then there will be no discussion. Besides, I was not sure how your post was in any relevance to what we were discussing.
>>
>>In any case, in my post I explicitly was talking about temp tables to avoid confusions.
>
>
>
>Ambiguous to you maybe.... anyway... i'm not arguing with you ..bye
So, what is a temp variable in SQL? AFAIK there are temp tables and table variables, then you have local variables, but even though I admit am new to SQL server I have never heard of temp variables?
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges