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

  • 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 🙂

  • No difference. The INTO argument is optional.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply