Jul 17, 2003 #1 sbraaa Programmer Oct 7, 2002 3 IT Hi, my question is: update table set field1 = 0; update table set field2 = 0; update table set field3 = 0; update table set field4 = 0; or update table set field1=0, set field2=0, set field3=0, set field4=0 which is the fastest?
Hi, my question is: update table set field1 = 0; update table set field2 = 0; update table set field3 = 0; update table set field4 = 0; or update table set field1=0, set field2=0, set field3=0, set field4=0 which is the fastest?
Jul 17, 2003 #2 ceco IS-IT--Management Oct 16, 2002 229 BG i haven't tested it, but for no reason the first should be faster so the second one is better Upvote 0 Downvote