title: Column name or number of supplied values does not match table definition without dropping table
body: <p>In SQL server, I am trying to insert values from one table to another by using the below query:</p>
  
  <pre><code>insert into tblTable1 (
    [Week],
    20001,
    20002,
    20003,
    20004,
    20006,
    20005,
    W/c
  )
  select *
  from tblTable1_link (
    [Week],
    20001,
    20002,
    20003,
    20004,
    20006,
    20005,
    W/c
  )
  </code></pre>
  
  <p>I am getting the following error:</p>
  
  <blockquote>
    <p>Server: Msg 170, Level 15, State 1, Line 1<br>
    Line 1: Incorrect syntax near '20001'.<br>
    Server: Msg 170, Level 15, State 1, Line 1<br>
    Line 1: Incorrect syntax near 'Week'.</p>
  </blockquote>
  
  <p>I am sure that both table having same structure,column names and same data type:</p>
  
  <pre><code>Please see the structure below:
  
  sp_columns tblTable1_link
  
  database_name   USERACCOUNT tblTable1   Week    4   int 10  4   0   10  1   NULL    NULL    4   NULL    NULL    1   YES 38
  database_name   USERACCOUNT tblTable1   20001   -9  nvarchar    255 510 NULL    NULL    1   NULL    NULL    -9  NULL    510 2   YES 39
  database_name   USERACCOUNT tblTable1   20002   -9  nvarchar    255 510 NULL    NULL    1   NULL    NULL    -9  NULL    510 3   YES 39
  database_name   USERACCOUNT tblTable1   20003   -9  nvarchar    255 510 NULL    NULL    1   NULL    NULL    -9  NULL    510 4   YES 39
  database_name   USERACCOUNT tblTable1   20004   -9  nvarchar    255 510 NULL    NULL    1   NULL    NULL    -9  NULL    510 5   YES 39
  database_name   USERACCOUNT tblTable1   20006   -9  nvarchar    255 510 NULL    NULL    1   NULL    NULL    -9  NULL    510 6   YES 39
  database_name   USERACCOUNT tblTable1   20005   -9  nvarchar    255 510 NULL    NULL    1   NULL    NULL    -9  NULL    510 7   YES 39
  database_name   USERACCOUNT tblTable1   W/c 11  smalldatetime   16  16  0   NULL    1   NULL    NULL    9   3   NULL    8   YES 111
  
  database_name   dbo tblTable1_Link  Week    4   int 10  4   0   10  1   NULL    NULL    4   NULL    NULL    1   YES 38
  database_name   dbo tblTable1_Link  20001   -9  nvarchar    255 510 NULL    NULL    1   NULL    NULL    -9  NULL    510 2   YES 39
  database_name   dbo tblTable1_Link  20002   -9  nvarchar    255 510 NULL    NULL    1   NULL    NULL    -9  NULL    510 3   YES 39
  database_name   dbo tblTable1_Link  20003   -9  nvarchar    255 510 NULL    NULL    1   NULL    NULL    -9  NULL    510 4   YES 39
  database_name   dbo tblTable1_Link  20004   -9  nvarchar    255 510 NULL    NULL    1   NULL    NULL    -9  NULL    510 5   YES 39
  database_name   dbo tblTable1_Link  20006   -9  nvarchar    255 510 NULL    NULL    1   NULL    NULL    -9  NULL    510 6   YES 39
  database_name   dbo tblTable1_Link  20005   -9  nvarchar    255 510 NULL    NULL    1   NULL    NULL    -9  NULL    510 7   YES 39
  database_name   dbo tblTable1_Link  W/c 11  smalldatetime   16  16  0   NULL    1   NULL    NULL    9   3   NULL    8   YES 111
  </code></pre>
  
  <p>I cannot drop the source table, I want to insert data without dropping</p>
  
  <p>This query resulted:</p>
  
  <p>select * into tblTable from tblTable_Link</p>
  
  <p>Error: </p>
  
  <p>Server: Msg 2714, Level 16, State 6, Line 1
  There is already an object named 'tblTable' in the database.</p>