Home Forums SQL Server 2008 T-SQL (SS2K8) SELECT * INTO TABLE RE: SELECT * INTO TABLE

  • February 7, 2014 at 4:23 am

    #1686970

    hoseam (2/7/2014)

    I have this code

    select *

    INTO Hosea_tempTable

    from Hosea_tblDATA_Product_Reports

    and I get this error;

    There is already an object named 'Hosea_tempTable' in the database

    Yes, that's because SELECT INTO attempts to create a table that already exists in your database. You want to be using INSERT INTO instead.

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn