SQLTeam.com | Weblogs | Forums

Tables Variables ARE Stored in tempdb

Well here's something I never knew. When you declare a table variable it does get instantiated into tempdb.dbo.sysobjects. I was under the impression it wouldn't. If you run this code...

This is a companion discussion topic for the original entry at http://billg.sqlteam.com/2003/12/07/641/