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
Post a Comment