Results 1 to 2 of 2
  1. #1
    Join Date
    May 2005
    Posts
    12

    Unanswered: Interesting to add several columns at once ?

    Hi,

    Do you think it is more rapid to add 20 columns in one SQL statement, rather than issuing 20 SQL add column statements ?

    THX

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Well, it probably isn't worth worrying too much about it either way, but yes I would expect it to be faster, as there is only one statement overhead rather than 20.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •