<p>SQL Server (2005/2008)</p>

<p>Each of the below statements have the same result. Does anyone know if one outperforms the other?</p>

<pre><code>insert into SOMETABLE 
  values ('FieldOneValue','FieldTwoValue',3,4.55,'10/10/2008 16:42:00.000')

insert into SOMETABLE 
  select 'FieldOneValue','FieldTwoValue',3,4.55,'10/10/2008 16:42:00.000'

insert into SOMETALBE
  Select
    Field1 = 'FieldOneValue',
    Field2 = 'FieldTwoValue',
    Field3 = 3,
    Field4 = 4.55,
    Field5 = '10/10/2008 16:42:00.000'
</code></pre>

<p>Assuming of course that the data types match the table appropriately...</p>

It looks like you're just mimicking
```
```
INSERT into SOMETABLE
(
SELECT * FROM SOMEOTHERTABLE
)
```
```