SELECT INTO

• williamminor

  SSCommitted

  Points: 1664

  More actions

  June 28, 2007 at 12:57 pm

  #372668

  I need to copy some databases into a reporting database. I'm using a metatable to house the information needed to do the process. Can I use the SELECT INTO statement to get the Index info along with the data? If so can someone give me the syntax

   

  Thanks

  -WM 

• Crispin Proctor

  SSCoach

  Points: 18161

  More actions

  June 29, 2007 at 1:47 am

  #716086

  No.

  Select into makes a basic copy of the table.

  You'll have to create the table with indexes and do a normal insert

  Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!