• Home
  • Blog
  • About Me
  • Home
  • Blog
  • About Me
SQL

Using Select into in Sql server

By Joe Gill  Published On 4th August 2006

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 Cancel reply

You must be logged in to post a comment.

Microsoft Dynamics CRM Installabpaction error
Previous Article
SQL Server Express Error 17053
Next Article