Thursday November 26th

Wednesday November 25th

2 Kicks

SQL Server 2005 temporary tables bug, feature or expected behavior?

Some unexpected SQL Server behaviour around temporary tables that is good to know about. If it can be explained...


Hi Mladen,

This is a good example for us to see the usage of GO and temp table. Within one batch, we can't use into to create the same temp table twice. That's why the SQL engine (not sure exact name but kind of) quickly found this syntax error and complained.

Commenting on Stories is limited for now and will open up to those recommended by the community. Learn how
Loading DotNetKicks...
brought to you by the Kicks Network