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.

Leave a Reply

Your email address will not be published. Required fields are marked *