Friday, August 04, 2006

Using Select into in Sql server

It's a No No
Don’t use select into as it locks the tempdb for the duration of the select. You have to create the temp table fist and then do a insert … select … from. Need to look at it this in SQL 2005.