SQL Server: How to load data from one table into the other?

Posted on 2014-08-05
Last Modified: 2016-02-11

I am loading data with 'select * into ...' statement, wondering if there is better, faster way to accomplish the task, ex SSIS package, bulk load etc.

Question by:quasar_ee
    LVL 68

    Accepted Solution

    Nope, that's the fastest way.
    LVL 75

    Expert Comment

    by:Anthony Perkins
    I would be more inclined to do a:
    CREATE TABLE MyTable ...
    INSERT MyTable ...
    LVL 14

    Expert Comment

    by:Vikas Garg

    If creating table while inserting then

    Select * into is best.

    If adding to existing table with data then Drop index load data then recreate index.

    You can also use SSIS with Fast Load option

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    My client sends data in an Excel file to me to load them into Staging database. The file contains many sheets that they have same structure. In this article, I would like to share the simple way to load data of multiple sheets by using SSIS.
    My client has a dictionary table. They're defining a list of standard naming convention. Now, they are requiring my team to provide us a mechanism how to match new incoming data with existing data in their system.
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now