Post reply

Updating table in queue

  • November 5, 2008 at 11:14 pm

    #383315

    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 ?

  • November 6, 2008 at 5:49 am

    #894783

    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]

  • November 6, 2008 at 7:29 am

    #894852

    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.

  • November 6, 2008 at 8:24 am

    #894927

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


    * Noel

  • November 6, 2008 at 8:31 am

    #894935

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

  • November 7, 2008 at 2:37 pm

    #895836

    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