Since this can be one of the mostly asked interview questions, I better have the answers here instead of doing another round of Googling.
1. table variable does not support transaction while temp table does
2. table variable does not support constraints while temp table does
A full expiation is here.
Showing posts with label temp table. Show all posts
Showing posts with label temp table. Show all posts
Monday, September 7, 2009
Subscribe to:
Posts (Atom)