promotion image of download ymail app
Anonymous asked in Computers & InternetProgramming & Design · 1 decade ago

I've made a asp page that a user clicks through to update a table column in a SQL database?

However, it does about 20 to 30 updates. Based on how many attributes the users check in the ASP page. The question is this. Is there a query that will lock the database at one instance and update the records all at once. I found the LOAD DATA technique however, it dosen't have respect to WHERE.

2 Answers

  • 1 decade ago
    Favorite Answer

    search for "ms sql lock nolock" in google and you will find what you are looking may also look for "bulk update ms sql"

    • Commenter avatarLogin to reply the answers
  • 1 decade ago

    I do not have a good answer for asp but php has the WHERE function you seem to be looking for.

    • Commenter avatarLogin to reply the answers
Still have questions? Get your answers by asking now.