What is the difference between insert-insert with and without attachment?

Question

I created a #temp table with id columns as int identity(1,1) and name as varchar .

Suppose I write the following two different statements to insert rows:

 insert into #temp (name) select ('Vikrant') ; insert #temp (name) select ('Vikrant') 

I want to ask, what is the difference between these two types of insert statements? Is there any difference between these inserts?

Answer 1

From the MSDN documentation :

[INTO] This is an optional keyword that can be used between INSERT and the target table.

There is no difference between the two statements.