>>>>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?


I guess we use the "wrong" terminology here... anything that is preceded by @ is a temp variable . You knew exactly what I meant and so did Naomia...