Diffrance between bulk copy by insert into [table name] select * from ..... and insert [tablename] select * from .......

• hemangi.gujar-600495

  SSC Rookie

  Points: 35

  More actions

  October 3, 2008 at 1:23 am

  #382934

  Hi all,

  I am using SQL server 2000 ,I want to bulk copy data from one table to other so I have use following quires.Both are working fine for me.But I want to know difference of it.(Provided:-I do not have primary key on any table.)Can you please let me know difference of these two.

  Insert into

  select * from

  OR

  Insert

  select * from

  Thanks in advance 🙂

• Clive Strong

  SSChampion

  Points: 11222

  More actions

  October 3, 2008 at 10:08 am

  #880572

  No difference. The INTO argument is optional.