In Sql Server

If you are using Insert or Insert into both will insert the data in Table.

However Insert into is basically used to fatch the data from another table...