insert into: syntax some-more optimal preference?


sql server (2005/2008)



each next statements have same result. does anyone know outperforms other?



insert sometable 
values ('fieldonevalue','fieldtwovalue',3,4.55,'10/10/2008 16:42:00.000')

insert sometable
name 'fieldonevalue','fieldtwovalue',3,4.55,'10/10/2008 16:42:00.000'

insert sometalbe
select
field1 = 'fieldonevalue',
field2 = 'fieldtwovalue',
field3 = 3,
field4 = 4.55,
field5 = '10/10/2008 16:42:00.000'


assuming impetus information forms review list appropriately...



Comments

Popular posts from this blog

list macos calm editors formula editors

how hibernate @any-related annotations?

why does floated <input> control floated component slip over too distant right ie7, nonetheless firefox?