Insert data from one table to the other

[wg26]

Hi Everyone:

I have one empty table with two column([Name] varchar, [LookupId] uniqueidentifier default newid()) and I am trying insert data which retrieve from other table into this table... the code is as the following:

Insert into [Detail Name Lookup_2][([Name], default)]
Select distinct [Name]
from [Detail]

But SQL keeps giving me error as: Incorrect syntax near '([Name'......

Can anyone please kindly give me some suggestions about what is wrong with my code? Thanks alot...

 

[JamesLean]

INSERT [Detail Name Lookup_2]([Name])
SELECT DISTINCT [Name]
FROM [Detail]

The default values will be inserted automatically

 

[wg26]

I just found out that...but Thanks alot anyway...