Well Wayne, it works perfectly in my local sqlserver (home computer) but it does not work in server at my office.

At my office when i ran the code it...

Thanks. It makes sense.

The following sql statement only shows table variable in tempdb database if execute them all at a time.

If i execute the last two sql statements separately the table variable...

You are correct. I just executed the following sql statements in my personal machine and i can see the table variable in tempdb database. Maybe it is something to...

Oh! I still don't understand why it is not showing for me, Its just zero rows when i execute last sql statement. However i will read the article.

Comparing Table Variables with Temporary Tables

I ran the following piece of code in SQL-Server 2005 and i can not see any entry of table variable in tempdb database. I can...