Updating table in queue

  • HI,

    Any idea about ' How to update a table in queue' .

    Assuming that there are 5 updates happening on a table. How do I queue these updates ?

  • If you're asking how to ensure that updates coming from different sources go through one at a time, you can use transactions. That said, I don't believe you need a transaction if it is just a single table you are updating.

    Seth Phelabaum


    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

  • Can you explain exactly what you need?

    SQL will handle multiple updates automatically by locking the table and processing records based on the ACID properties. So I think we would need to know your intentions or what the goal is to assist further.

  • You need to explain your intentions better if you want an answer


    * Noel

  • need more information (exact requirement) about question ? so that I can help.

  • what is your purpose exactly ?

    if distinct sources are updating the same table at approximately the same time, SQL Server will process them one after the other.

    You could have problems if this done as part of long, time-consuming stored procedure.

    What practical effects would there be for you if source #4 made the first update, followed by source #1 ? this is exactly what you would get if source #1 manifests itself well after the table has been updated upon request from source #1 anyway...

    why should the order of the updates be important to you ?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply