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 i practical urls indicate .aspx pages asp.net deployed an iis? (preferably but iis)

jaxb - xjc - reworking generated typesafe enum category members